Error 8925
Severity Level 16
Message Text
Table error: Cross object linkage: Page %S_PGID, slot %d, in object ID %d, index ID %d, refers to page %S_PGID, slot %d, in object ID %d, index ID %d.
Explanation
This error occurs when Microsoft® SQL Server™ detects an inconsistency in the page linkage of one of the page chains associated with a table. One of the pages has been found to be linked in more than one page chain when it should be linked in only one chain. There is one doubly-linked page chain for the table data, as well as one for each index level.
Important This is a serious error and must be corrected immediately.
If DBCC CHECKDB without a repair clause detects this error during run-time processing, error 605 can also occur.
Action
Follow these steps to resolve the error:
- Examine the index ID associated with the page number indicated 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 = 0), 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.