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!!
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.