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 |
|
underwoodmf
Starting Member
1 Post |
 Posted - 2012-10-15 : 14:19:25
|
| I have an '08 instance that has two dbs. One of them started getting the 605 logical fetch error a few days ago. It's now hung "in recovery". How can I get it out of recovery and restore the db using only the database file from the OS level backup(no SQL Server backup available)?? Help!!Mark Underwood |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-10-15 : 14:22:38
|
| If you have the MDF and LDF backed up (You would have had to stop SQL for these files to be validly backed up) just attach the database. Try it on another server first to makes sure the MDF and LDF are valid.-Chad |
 |
|
|
prett
Posting Yak Master
212 Posts |
Posted - 2012-10-16 : 00:12:08
|
| First check your SQL Server ERRORLOG and mention error message here. |
|
|
|
|
|
|
Restoring a db from OS file