Resolve “Server: Msg 8966” & “Server: Msg 8944” Errors Article

	1888 Articles Home \| Computer Articles \| Data Recovery Articles	Data Recovery RSS
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.

Author: Gaurav Kumar

Article Tools:

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)

About Author

Gaurav work as a freelancer and researcher for Data Recovery & SQL Database Recovery Software.
For more information visit: http://www.datarecovery-info.com

Article Source: http://www.1888articles.com/author-gaurav-kumar-36016.html