[dba-VB] Half the databases in recovery

Makes you happy you had that backup though just in case huh?

Perry
----- Original Message ----- 
From: "jwcolby" <jwcolby at colbyconsulting.com>
To: "VBA" <dba-vb at databaseadvisors.com>; "Sqlserver-Dba" 
<dba-sqlserver at databaseadvisors.com>
Sent: Wednesday, June 09, 2010 10:09 PM
Subject: [dba-VB] Half the databases in recovery


> 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
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>