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: 244

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

Related posts about sql-server

Related posts about sql-server-2005