Error 2511

Troubleshooting SQL Server

Troubleshooting

Error 2511

Severity Level 16
Message Text

Table Corrupt: Object ID %d, Index ID %d. Keys out of order on page %S_PGID, slots %d and %d.

Table error: Object ID %d, Index ID %d. Keys out of order on page %S_PGID, slots %d and %d.

Explanation

This error occurs when an index is not ordered correctly. The %S_PGID variable can be a data page (for clustered indexes), an index page, or a leaf page.

Action

The fastest way to resolve this problem is to execute DBCC CHECKDB with the REPAIR_REBUILD clause. This fixes any index corruption in the entire database. If the database is so large that you do not want to run DBCC CHECKDB, use these instructions to locate the specific table that is corrupt. Then, execute DBCC CHECKTABLE with the REPAIR_REBUILD clause for that table.

Important  If executing DBCC CHECKDB or DBCC CHECKTABLE with the REPAIR_REBUILD clause does not correct the index problem or if you are unsure what effect either of these DBCC statements with the REPAIR_REBUILD clause has on your data, contact your primary support provider.

Follow these steps:

  1. Note the object ID.

  2. If the object with the error is not a system table (its object ID is more than 100), continue with the next step.

  3. If the object with the error is a system table (its object ID is less than 100), you cannot drop the index. Restore the database from a known clean backup.

  4. Find the name of the index involved, as follows:
    USE master
    GO
    SELECT name 
    FROM sysindexes
    WHERE indid = index_id
        AND id = object_id
    
  5. Drop and re-create the index.

  6. Run DBCC CHECKTABLE on the affected table to verify that all problems have been resolved at the table level.

If problems persist, contact your primary support provider. Have the output from either DBCC CHECKDB or DBCC CHECKTABLE available for review.

See Also

DBCC CHECKDB

DBCC CHECKTABLE

Errors 2000-2999

Reporting Errors to Your Primary Support Provider