sql server 2005 instance unresponsive and all db's are 'in recovery'
Posted
by user44650
on Server Fault
See other posts from Server Fault
or by user44650
Published on 2010-06-01T14:53:32Z
Indexed on
2010/06/01
15:04 UTC
Read the original article
Hit count: 240
we've got a sql server 2005 instance that one of our guys messed up, i believe they killed the sql server service and restarted the computer, and when it came back all of our databases are "in recovery" and it times out every time we try to connect to it. it's been 'in recovery'and unable to connect to 'msbd' (also in recovery) whenever we try to use SSMC, for the last 4 days now. i'm unsure how to use the DBCC CHECKDB command to check the db integrity. we have backups(which we can't recover from because it keeps timing out), and it's a testing server, so nothing in production is really lost. is there any way to get it out of recovery mode? we have another sqlserver instance running that's just fine, but this instance keeps timing out. the errors i keep seeing are
database msdb is being recovered. wait until recovery is finished
and
an exception occurred while executing a transact-sql statement or batch Timeout expired.
any thoughts? we don't really have a DBA here, or anyone with much sql experience.
© Server Fault or respective owner