January 4, 2007 at 4:47 am
Came in this morning and found one database stuck in recovery mode. Tried re-booting but that didn't help. Will let me expand all other databases but not this one - the hour glass seems to be there forever. Tried detaching, delete but that diesn't work either.
Won't let me into QA (some time out message) to select any databases. I have backup of the database so I am happy to delete it but it wont let me. Grateful for any help.
January 4, 2007 at 5:58 am
well you should be able to drop the database - however I'd have been through the logs first before rebooting, unless the database isn't important. Stop the server and delete the mdf and ldf files - brutal but it will work, when you restart it will show as suspect ( as it's not there! ) just delete the database.
You can normally restore over the top of a suspect or recovering database, so you might try that too.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 5, 2007 at 4:06 am
Have you got enough disk space...?
January 5, 2007 at 4:30 am
whats the size of the database. check your event viewer for any errors in the disk also check for the error log and let us know whats the exact error message
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
January 5, 2007 at 8:51 am
Most likely the problem is that your last restore was done using WITH NORECOVERY. To fix this, just run this...(replace dbname with the real database name)
RESTORE DATABASE dbname WITH RECOVERY.
-SQLBill
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply