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

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Cannot Attach database in 2005

Author  Topic 

anupnair
Starting Member

1 Post

Posted - 2007-08-22 : 01:36:40
A DB was in suspect mode I detached & tried to re- attach the db. but it return below error

SQL Server detected a logical consistency-based I/O error: torn page

There are no good backups available for this can anybody help

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-08-22 : 09:03:08
Why no backups?

The only thing you can do is follow these steps http://www.nigelrivett.net/RecoverCorruptDatabase.html



-ec
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-08-22 : 09:04:49
Also, make sure you use a copy of your db datafiles, not the originals. You might need to try things several times.
Go to Top of Page
   

- Advertisement -