Error 8925

Severity Level 16

Message Text

Table Corrupt: 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:

1. 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.
2. 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 problem persists, contact your primary support provider for assistance. Have the output of the appropriate DBCC statements available for review.

See Also