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 |
|
thisisjeff
Starting Member
1 Post |
 Posted - 2006-04-13 : 10:50:32
|
| Hi,I backed up a database to drive f:, then did restore and set options to move the .mdf and .ldf files to different HDs (f: for .mdf and d: for .ldf).During restore I got a disk IO error. The restore terminated abnormally. Now I have no DB but the .mdf and the .ldf have been moved to the HDs that I specified in the restore options.I cannot move the .bak file from the f: it gives me an IO error when I try this. It did allow me to copy the .mdf from f: to d:I need to know how to recover the db frm the .mdf and .ldf files. I have tried using sp_attach_db and got the following error:An error occurred while processing the log for database 'MyDB'Please help.Thank you,Jeff |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-04-17 : 17:32:20
|
| Do you have the original MDF and LDF files, or just those created by the restore?Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine + SQL Express(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-04-17 : 17:52:57
|
| It sounds like you have a disk problem which has corrupted the backup file. The restaore didn't complete so the mdf/ldf files aren't complete.I suspect you won't be able to do much with any of those files.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
restore database failed