Error 1117

Severity Level 21

Message Text

Extent chain for object %ID is not correctly linked.

Explanation

This error occurs when the extent chain used to manage the space allocation for an object is not linked correctly. This may be the result of hardware or operating-system problems.

Action

Execute DBCC CHECKDB and DBCC NEWALLOC. If DBCC CHECKDB reports no errors, the data in the object is most likely unaffected. Follow these steps:

  1. Load the database from backup.
  2. Bulk copy the data out, drop the table, re-create the table, and then bulk copy the data back in.

    Important The extent linkages are used to drop an object, and the drop command may fail. Before attempting any repairs, make a physical backup of the physical device files.

  3. Execute SELECT INTO another table, drop the original table, and then use the sp_rename stored procedure to change the name of the table back to the original name.

    Important The extent chain is used as the means to determine what extents to deallocate when an object is to be dropped; the drop table statement may fail. Before attempting any repairs, shut down SQL Server and perform a physical file backup of database device files on the server.

To confirm that the most current versions of software and hardware are being used, run hardware diagnostics and contact your hardware vendor.

If you are unable to resolve this problem, contact your primary support provider. Have the SQL Server error log and the DBCC CHECKDB and DBCC NEWALLOC output available for review.