Thursday, September 24, 2009

Sysindexes.statblob Column Corruption after Running DBCC DBREINDEX Statement

After you apply the DBCC DBREINDEX T-SQL statement to rebuild one or more of the indexes for a database table in a particular SQL Server 2000 database, the indexes and statistics of the database may get damaged. This behavior results as data inaccessibility and database corruption which causes data loss. In order to resolve such behavior of Microsoft SQL Server 2000, you should opt for SQL Recovery solutions.

After running DBCC DBREINDEX statement on SQL Server database, the sysindexes.statblob column might get corrupted if the following conditions are true:

The table has a computed column.
Some columns in the table are referenced by more than one indexes or statistics.
The table is referenced by an indexed view.
You have re-indexed the table using DBCC DBREINDEX command.

Auto create statistics option is enabled for database.

When you run the DBCC CHECKDB command on the database, you come across the following corruption error messages on sysindexes.statblob column:

Server: Msg 8964, Level 16, State 1, Line 2 Table error: Object ID 2. The text, ntext, or image node at page (1:64), slot 29, text ID 6815744 is not referenced.
Server: Msg 2576, Level 16, State 1, Line 2 IAM page (0:0) is pointed to by the previous pointer of IAM page (1:88) object ID 1977058079 index ID 2 but was not detected in the scan.

Corruption to the sysindexes.statblob column might also damage the whole MDF file.

Sysindexes.statblob is a column of sysindexes table which is used by SQL Server to store statistics of a column or an index key. It is an image data type which stores a histogram with a sampling of values in column or index key.

The ultimate result would be the inaccessibility and loss of your mission critical data. Thus, you need to perform SQL Repair to resolve this problem and to get your data back.

This is best possible with the help of powerful third-party SQL recovery applications. These software use effective scanning mechanisms to thoroughly scan entire MDF file and extract all data from it. The software come with interactive interface and to-the-point documentation that enables you to perform SQL Repair on your own.

SQL Recovery is the most comprehensive SQL Repair software that can repair and restore damaged MDF files in most of the data loss situations. It can repair and restore MDF files of SQL Server 2005 and 2000. The software is compatible with Windows Vista, XP, 2003, 2000 and NT.

No comments:

Post a Comment