Error 8956

Troubleshooting SQL Server

Troubleshooting

Error 8956

Severity Level 16
Message Text

Index row (%d:%d:%d) with values (%ls) points to the data row identified by (%ls).

Explanation

If Microsoft® SQL Server™ returns this error message, it always follows error 8952.

This error message indicates that one or more indexes are damaged and must be repaired or dropped.

Action

Repair indexes by executing DBCC CHECKDB with the REPAIR_ALLOW_DATA_LOSS, REPAIR_FAST, or REPAIR_REBUILD clauses. To determine which repair clause best suits your needs, consult DBCC CHECKDB before executing it.

Important  If executing DBCC CHECKDB with one of the repair clauses does not correct the index problem or if you are unsure what effect DBCC CHECKDB with a repair clause has on your data, contact your primary support provider.

See Also

DBCC CHECKDB

Error 8952

Reporting Errors to Your Primary Support Provider