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) <= LAST_REC_TYPE) failed.
Values are 14 and 12.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table
'sysindexes' (object ID 2).
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.”

Repairing Database Table:

To surmount the above error message and access the database table records, a DBA needs to delete the database table and restore the table from an up-to-date database backup. The option of restoring the table might fall short under below circumstances:

• DBA has not maintained full backup of the database table.
• The backup of database table is unavailable or incomplete.

In case the above problem persists due to any of the two reasons, then the DBA can opt for an third-party SQL recovery application that can repair the table and restore it at user-specified location.

Data Recovery Info:

A commercial SQL recovery tool repairs corrupted SQL database tables and brings them back in usuable state. Such recovery software also provide a preview of all the recoverable records saved in the table. The table can be restored at default or new location.

Applied For:

SQL Server 2005

How to Solve an ‘Unable to display the folder’ Error?

For those who use Microsoft Office Outlook, PST (Personal Storage Folder) corruption is an all-too-often incidence. Such can be the case when you receive one of the following error messages while opening MS Outlook or opening any of its folders:

“Error: Unable to display the folder”

A PST can get corrupted due to following reasons:

• PST exceeds its file size limit i.e. 2 GB
• You shut down the computer before exiting Outlook and hence closing PST
• You share the PST over a networked drive

Repairing PST

Microsoft Outlook comes with a pre-installed PST Repair utility called Inbox Repair Tool (Executable through Scanpst.exe file). The tool analyzes the entire PST structure and item headers. It then recovers whatever that is recoverable and deletes the unreadable.

To start with, take a backup of your corrupted PST and run Inbox Repair Tool (Scanpst.exe) on one of the PST files. To do so, follow these steps:

• Exit MS Outlook
• Click Start and then point to Search or Find (depending on your operating system)
• Type ‘scanpst.exe’ in Search for files or folders named box and hit ENTER
• Double click the file resulted in search results
• In Enter The Name Of The File You Want To Scan box, type the file name and path or locate the file using Browse
• Click Start
• After PST Recovery, launch MS Outlook and open the profile that is associated with the damaged PST
• The recovered folders and items can be viewed in Recovered Personal Folders or Lost and Found folder

If the PST is still not accessible, the file is probably damaged beyond repair. You might need to delete the damaged PST from the profile.

Data Recovery Info

 

In situations when Inbox Repair Tool fails to repair the PST, you can use a third-party tool. In contrast to Inbox Repair Tool, these PST Recovery Software run much effective scanning algorithms and do not delete the data. These are easily available tools and can help you get most out of your corrupted PST.

Applies To

• Microsoft Outlook 2002
• Microsoft Outlook 2000
• Microsoft Outlook 98
• Microsoft Outlook 97