January 25, 2011 at 10:30 am
Hi All
I am trying to attach a database, this has got 4 files one mdf, one ndf and 2 logfiles, while I try to attach this file, I face an error
"SQL Server detected a logical consistency -based I/O error " .
how can I attach this database, this holds one important piece of information that needs to be restored, please help me.
Please note I have attached the error with this post
Thanks for all your help in advance
Cheers
January 25, 2011 at 2:55 pm
First question is do you have a backup? If so, restore it run CheckDB and figure out where these 824 errors are coming from.
If you do not, here is a blog from Paul Randal (king of fixing corruption issues/writer of Checkdb) that shows you a number of things that you can try.
Based on your error message it looks like the secondary data file that is the problem so I am guessing you will have to try the section where he suggests creating a dummy database and getting the database in a suspect mode where you can actually do something with it. But go through his whole blog first and try to get a feel for what is really wrong with your data files.
Hopefully you have a backup somewhere, though. That would be ideal.
January 26, 2011 at 1:54 am
Thanks Mike
Unfortunately I don't have a backup :-(, I will go through the link and update you the process.
Cheers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply