Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Error 2570 in SQL Server
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sam.joseph74
Starting Member

USA
3 Posts

Posted - 06/03/2009 :  03:57:47  Show Profile  Visit sam.joseph74's Homepage  Reply with Quote
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.

tosscrosby
Aged Yak Warrior

USA
676 Posts

Posted - 06/08/2009 :  15:27:12  Show Profile  Reply with Quote
Check out:

http://www.sqlservercentral.com/articles/65804/

http://support.microsoft.com/kb/923247


Terry

-- Procrastinate now!
Go to Top of Page

Davidpoul
Starting Member

India
14 Posts

Posted - 06/09/2009 :  03:09:21  Show Profile  Visit Davidpoul's Homepage  Reply with Quote
To correct your 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’t run DBCC command to repair the database as it can’t 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 mdf files and SQL databases.


David Poul
http://www.repairmdf.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000