Error 2535

Troubleshooting SQL Server

Troubleshooting

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:

  1. 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.

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

See Also

DBCC CHECKALLOC

DBCC CHECKDB

DBCC CHECKTABLE

Errors 2000-2999

Reporting Errors to Your Primary Support Provider