Resolve "Server: Msg 8966" & "Server: Msg 8944" Errors

Resolve "Server: Msg 8966" & "Server: Msg 8944" Errors

DBCC DBREINDEX is a command used by DBAs to drop a previous index and then re-create a new index. The offline operation helps the DBAs to reorder indexes and recreate new disk space by compacting all the pages. While DBCC DBREINDEX command provides more optimization than executing separate DROP INDEX and CREATE INDEX commands, it is advisable not to use this command very frequently. A tightly packed database index is always a better option because there might be instances when after recreating indexes, the database table becomes corrupt and unmountable. In such situations, it becomes almost impossible to access the records saved in the database.

Furthermore, when a DBA tries to repair the table by using DBCC CHECKTABLE command, s/he might encounter the below error message:

"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)

POST COMMENT

Software application developers should focus on three key areas during their process lifecycle Dell, HP acquisition battle shows progress of cloud computing, hosted software QC Software Consulting Focused on Training Clients to Maximize WCS Benefits The amazing widget software review Companies Rely On Software For Buyer Traffic Runtime Error 2536 - You Need To Act Fast ! Hook.Dll Functions Error - Is It Fixable ? Need to Get Your Party Planning Organized? Get Help with Party Planning Software Amazing 3d Animation Software Software For Enrolled Agents Save Money When Buying Netbook Software Performance Tuning for Dealer Management System or DMS Software Kaka of Brazil squad for warm-up defeat terrorism Ronaldinho missed the World Cup lead