Error 2535
Severity Level 16
Message Text
Table error: Page %S_PGID is allocated to object ID %d, index ID %d, not to object ID %d, index ID %d found in page header.
Explanation
The DBCC CHECKALLOC statement detected a mismatch in the object ID between an allocation structure (extent) and sysindexes.
Note Occasionally, DBCC CHECKALLOC reports this error when no real error condition exists. Execute DBCC CHECKALLOC in single-user mode if you suspect the 2535 error is incorrect.
Action
Follow these steps:
- Examine the index ID associated with the page number in the message to determine whether the error occurred on the table data or on an index.
- Restore the database:
- If the object ID is less than or equal to 100, the error is on a system table. Restore the database from a clean backup.
- If the object ID is greater than 100, the error is on a user table.
- If this error occurs on table data (the index ID = 1), restore the database from a clean backup.
- If the error occurs on an index, you can usually correct it by dropping and re-creating the index. If dropping and re-creating the index is not feasible, or if you cannot drop the index, contact your primary support provider for assistance.
- If the object ID is less than or equal to 100, the error is on a system table. Restore the database from a clean backup.
If the problem persists, contact your primary support provider for assistance. Have the output of the appropriate DBCC statements available for review.