SQL SERVER ERROR 5228

Error: 5228, Severity: 16, Table error: object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID, row %d. DBCC detected incomplete cleanup from an online index build operation. (The anti-matter column value is %d.)

Most of the database user’s are customary to this error message while using the database. The Error 5228 occurs when intermediary state leads to the corruption of database. In SQL Server occurrence of errors while managing bulky data is a customary event, but the data recovery is crucial issue.

Reasons of Occurrence

SQL Server error 5228 occurs when intermediary state leads to the corruption. That means the database become in-accessible and display error message 5228 as shown above. As seen mostly the error 5228 occurrence is seen in SQL Server version 2000 and all above. Whenever the user perform delete, modify and add command on database and a partition index that is unfinished is identified in the PN_ID, O_ID object and I_ID index partition then intermediary state occurs leading to error 5228.

SOLUTIONS 

Mostly the user when identify this error state go for manual solutions such as Hardware diagnose, Backup restoration and run DBCC CHECKDB command. Most of the time these solutions are able to recover data but in some cases where these manual solutions are not a success SQL Repair can be helpful and to know more read  Error 5228 Blog.