[dba-SQLServer] Half the databases in recovery

jwcolby jwcolby at colbyconsulting.com
Wed Jun 9 21:09:03 CDT 2010


Holy smoke batman.  This time, the server locks up, I end up rebooting (after hours of waiting "to 
see") and about 15 different databases are "in recovery".  Man that will cause your heart to stop.

After only a few minutes I refreshed the databases and only one was still in recovery - the temp 
database that was being worked with when the lockup occurred.

I have never seen databases in recovery that weren't actively involved in operations when the lockup 
occurred.

Strange!

-- 
John W. Colby
www.ColbyConsulting.com



More information about the dba-SQLServer mailing list