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.
| Author |
Topic |
|
wkl2
Starting Member
5 Posts |
 Posted - 2006-06-02 : 13:19:53
|
| hello,I am helping out with a disaster recovery of a database and i was given 4 files. 2 MDF and 2 LDF files. When I try to attach the files to SQL Server I recieve this err msg:Server: Msg 823, Level 24, State 6, Line 1I/O error (torn page) detected during read at offset 0000000000000000 in file 'E:\chivirtual\GPS0Dat.mdf'.Connection BrokenI then tried many other combinations hoping something would work --> tried individual files, just data files, tried to create a new DB and then switching/replacing out with the files i needed...etc, nothing seems to work for me. The people I am trying to help out do NOT have backups.Any thoughts would be appreciated. thanks... |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-02 : 13:44:48
|
If the Torn page is in an Index then you can rebuild the index and you should be fine (I expect you need to do this on the original server, not the files you are trying to re-attach), if not and given "The people I am trying to help out do NOT have backups" I reckon you are hosed  Are there any earlier versions of the MDF files that you can try to attach?Hopefully the MS folk that check this forum can give you some better news ...Kristen |
 |
|
|
wkl2
Starting Member
5 Posts |
Posted - 2006-06-02 : 13:58:02
|
| The situation is pretty bleak. The original server is hosed. The files that were given me were originally deleted off their server and they actually used some disk recovery tool to recover these files. thanks for your input Kristen. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-02 : 14:17:47
|
| If you don't get an answer here you might like to re-post in the Corruption Issues forum.But they should have had a backup - no excuses I'm afraid!Kristen |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-24 : 02:42:02
|
| Conversation moved to: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67175 |
|
|
|
|
|
|
recovery/attaching Database files