Microsoft System Center Integration
cancel
Showing results for 
Search instead for 
Did you mean: 

Error during using DBCC CHECKDB

Error during using DBCC
Occasional Visitor

Error during using DBCC CHECKDB

When I check my database integrity using DBCC CHECKDB with DATA_PURITY option enabled and it gives the below error message:

“Msg 2570, Level 16, State 2, Line 1
Page %S_PGID, slot %d in Object %d Index %d Column %.*ls value %.*ls is out of range for data type "%.*ls". Update column to a legal value.”

Please suggest me what to do to overcome this problem.
2 REPLIES
Davidpoul
Occasional Visitor

Re: Error during using DBCC CHECKDB

To correct the above issue, you need to follow any of the below methods:

You should find the affected rows and manually update them with correct values. To do this, you can execute T-SQL (Transact-SQL) queries against the table or alternatively, refer to the information provided by error 2570. You can set it to any of acceptable default or specific value.

Note: You can not run DBCC command to repair the database as it can not determine the value to be placed instead of invalid column value.

In case if affected rows are large in number and it is not possible to update them manually, you can restore them from backup
If the above measure is not feasible because of backup unavailability or corruption, you need to use MDF Recovery applications to safely repair and restore your database. Such MDF Repair software use powerful scanning algorithms and offer advanced repair and restoration options together with interactive user interface. I like to suggest Stellar Phoenix SQL Recovery which is the foremost SQL Repair tool to repair damaged SQL databases.
http://www.mssqldatabaserecovery.com
DeploymentGuy
Occasional Visitor

Re: Error during using DBCC CHECKDB

Both of these accounts only made one post, and they were created one day apart.

I think this thread is spam. Beware of apps sold by spammers.