I'm currently running Windows Server 2003 and just recently installed SQL 2005. I had a few databases that I was attaching from the old SQL 2000 server. I encountered a hard error and when I restarted Management studio, I found 4 of my databases were in recovery. Thinking this would be a short process, I let it run and did work on one of my other machines. Nearly 2 hours later, the databases are still in recovery and nothing appears to have changed. I'm new to sql 2005 and don't know what the best method of bringing those databases back up would be. If it is possible to just detach the databases (or blow them away completely) I have backups that are plenty recent enough, however I find I am unable to make any changes to the databases while one of the system db's is in recovery. Any ideas?
KCanterucci,
I think you can find more accurate answer in sql server engine forum.
No comments:
Post a Comment