MS SQL Server has offered the database integrity check through a simple command called DBCC CHECKDB. This performs a set of operations and sees if there is any corruption in the database or not. With the help of few SQL repair options, the command can impart repair in many of the cases. The command reports corruption and shows its report in the form of error message, each having a specific meaning and reference.
Now, some database corruption issues have been seen when the database contains sql_variant data type. This is a data type which stores values of diverse SQL Server-supported data types, all in a common place.
DBCC CHECKDB command reports corruption symptoms, with the error messages such as:
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.
Or
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 ).
This particularly happens when the application loads data into the column of sql_variant data type which contains numeric values. Now, if the data initiates in some other column that is also a sql_variant data type and then, the data is sent on-the-wire by SQL Server. In this condition, data is sent to some other SQL Server or to an intermediate file and the corruption issues are seen with the database.
Microsoft has released its fix through latest service pack of SQL Server, but there is no answer for the corrupted database as such. But fortunately, file repair engineers have, who solve the issue in SQL recovery way. They offer MDF repair software which can scan the database and make repair possible with the use of powerful algorithms.
MDF recovery utilities are designed with the technology to be functional in each corruption case and offer ease of use via the interactive interface.
The best SQL recovery option is available through Stellar Phoenix SQL Database Recovery which is a splendid application and has been instructed to use the algorithms which actually work. This SQL repair software is found to be compatible with SQL Server 2000 and 2005.
Moreover, it will impart MDF recovery for all the database objects and is considered safe as of the read-only conduct. To let experience the interface qualities and operational abilities, manufactures have availed the free demo version of this MDF repair utility on their website.
