Tuesday, March 16, 2010

DBCC CHECKDB Reports Corruption in Microsoft SQL Server

Is DBCC CHECKDB statement giving you consistency errors while checking the integrity and consistency of SQL Server database? This behavior occurs due to corruption to MDF (Master Database File) of Microsoft SQL Server and renders all your valuable data inaccessible. It leads to critical data loss situations. In order to get your mission-critical data back in such cases, SQL Database Recovery through reliable applications, is required.

The consistency errors are reported by DBCC CHECKDB tool, if the below situations true:

SQL Server loads the data in a column, which has sql_variant data type.
Data is originated in another column, having sql_variant data type. Additionally data is placed on-the-wire by MS SQL Server.
Numeric values are stored in sql_variant column.

Following are a few instances of SQL statements, which can result into this behavior:

The INSERT..SELECT statement, which specifies remote server in FROM clause of SELECT statement.
A BULK INSERT or a bcp statement from the file, which was created by SELECT statement from the SQL Server.
The database load through Data Transformation Services.

At the same time, you may also receive error messages similar to the following ones:

Server: Msg 2537, Level 16, State 43, Line 1 Table error: Object ID 587149137, index ID 0, page (1:1325), row 0. Record check (innerLength <= innerColInfo.CbMaxLen () && innerPCol != NULL) failed. Values are 17 and 5.
Server: Msg 2537, Level 16, State 1, Line 1 Table error: Object ID 587149137, index ID 0, page (1:1325), row 0. Record check (Valid SqlVariant) failed. Values are 1 and 0.
DBCC results for 'myvar2'. There are 1 rows in 1 pages for object 'myvar2'. CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'myvar2' (object ID 587149137). repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (pubs.dbo.myvar2 ).

Microsoft offers a hotfix to sort out this problem, which can be downloaded from Microsoft's website. To repair and restore the damaged Microsoft SQL Server database, third-party SQL Server Recovery software can help you.

The MS SQL Recovery applications employ advanced scanning algorithms to thoroughly scan entire database and restore it to working state. They come equipped with simple and self-descriptive graphical user interface and allow you to carry out SQL Recovery on your own.

SQL Recovery is the most efficient utility that ensures absolute recovery in all MDF corruption scenarios. It works well with Microsoft SQL Server 2008, 2005, and 2000. The software restores all database objects such as tables, reports, forms, stored procedures, triggers, and constraints.

No comments:

Post a Comment