SQLTeam.com | Weblogs | Forums

How to read query data from DBCC error messages?

sql2008r2

#1

I have a database that failed a DBCC CHECKDB query. The errors I'm getting look like this: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1592717712, index ID 1, partition ID 72058249460056064, alloc unit ID 72057732023910400 (type LOB data). The off-row data node at page (1:3733638), slot 9, text ID 4036995186688 is not referenced.

Is there any way to determine what row in the table this references? I was able to get the table name from the Object ID, but I don't know how to read the rest of it.


#2

The reason could be the bad shutdown of SQL Server, malware attack, hardware issue etc. Here is the quick solution to resolve SQL Server error 8946:
https://www.sqlrecoverytool.com/fix-sql-server-error-8946.html