Easy Way to Fix SQL DBCC Error 2570 in MS SQL 2005

MS SQL Server 2005 is considered as one of the reliable database management system. It offers safe and easy management of data and hence being widely used by large numbers of people all over the world. While working on database you receive various kinds of database consistency errors due to which your database becomes inaccessible. In order to check the consistency of database SQL is provided with DBCC CHECKDB utility. This inbuilt utility check the integrity of database and repair the damage. But at times it happens that the utility fails and you receive SQL DBCC error 2570.

Since, SQL uses primary query languages and execute various types of queries while working on the database. At times if happens that you receive incorrect results while executing certain query and receive several exceptions. It might be possible while using Remote Call Procedure in SQL or performing bulk insert some invalid values get stored in the database and corrupt the database. Due to this reason you receive various errors or access violation.

In order to check such issues related to consistency errors users execute DBCC command with DATA_PURITY’ option but unfortunately utility fails to work and give rise to SQL DBCC error 2570 which appears in following format.

“Msg 2570, Level 16, State 2, Line 1 Page (1:1073), slot 33 in object ID 1977058079, index ID 0, partition ID 129568478265344, alloc unit ID 129568478265344 (type "In-row data"). Column "account_name_japan" value is out of range for data type "nvarchar". Update column to a legal value.”

The major cause behind the occurrence of this error is presence of invalid data in any of the column of the table. It might be possible that invalid floating point values like QNAN, ND, NINF, PINF etc are present in the column due to which you receive database consistency errors like 2570.

In order to fix SQL DBCC error 2570 you need to locate the column and correct the affected values manually. It can be done as follows:

  • Find the column or row containing the invalid entries and replace them with logically correct values, NULL value, default value for that column, maximum or minimum value etc
  • Following this method you will bale to resolve this problem but in the case if you are unable to replace the values and update the column manually which generally occurs in the case if you have got large numbers of affected rows and columns then you need to replace the database using current backup

In the case if you don't have backup available and you are unable to fix SQL DBCC error 2570 then you need to use third-party MS SQL Database Repair Software. With the help of this effective software you can easily repair and restore damaged database. The software works in all versions of MS SQL server.