Dbcc Checktable Displays 8966 And 8944 Error Messages

Records stored in a MS SQL Server table become inaccessible when it gets corrupted

due to record header corruption, metadata structure damage, application malfunction, and concurrent modification. To surmount table corruption, MS SQL Server provides an inbuilt table repair command known as 'DBCC CHECKTABLE'. The command checks the logical and physical integrity of the corrupted table and the indexed view. While in most cases, the command is successful in repairing corrupted tables, there are a few instances where the command falls short in repairing the MS SQL Server table. In such situations, the command displays an error message, exhibiting the exact reason for its failure. The table remains corrupt after DBCC CHECKTABLE failure message. To overcome such table corruption, an ideal option is to restore the table from an updated backup. However, in the absence of or in case of deficient table backup, the user needs to use a powerful third-party MDF Repair utility.

To explain the above scenario in detail, consider a practical case where you encounter the below error message while attempting to repair your corrupt table using DBCC CHECKTABLE command:

Server: Msg 8966, Level 16, State 1, Line 1

Could not read and latch page (1:24) with latch type SH. sysindexes

failed.

Server: Msg 8944, Level 16, State 1, Line 1

Table error: Object ID 2, index ID 0, page (1:24), row 11. Test

(!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_A | RECTAG_RESV_B)))

failed. Values are 95 and 193.

Server: Msg 8944, Level 16, State 1, Line 1

Table error: Object ID 2, index ID 0, page (1:24), row 11. Test

(GetRecType (pRec) >= 0 && GetRecType (pRec)

by: mark willium

POST COMMENT

Revolution In Software Development Recovering Sql Server Database From Error: 5171 Deciding On The Best Free Fat Loss Software Things to Remember when Acquiring for POS Software Courier Software Implementation: Avoiding Problems Property Management Software: A Cost-effective Investment Tidysongs Free Version-A good software to manage your favoriate songs Surgical Error Lawyers Wii Unlock Plus Free-Unlocking software that really works Tidysongs Free Code-Tidysongs is a wonderful and cheap software which can deal with all the songs successfully Resolving incorrect Key File For Table.. Error In Mysql Fixing Few Common Partition Table Corruption Errors Recovering Sql Server 2008 Database From Error 2008