Today I have rebooted my Win2008 Server with SQL Server 2008 running on it. After rebooting SQL Server marked my database as "In recovery", so I can't use this database until recovering finished. The question is - how much dose it takes to finish recovery process and does it actually do the recovery (or SQL Server just lock my db and nothing gonna happens)?
+3
A:
Yes it works (for example, cluster failover relies on it).
However, it could be slow for many reasons.
First, refresh SSMS/check SQL error log to see if it has complted
Second, read these while you wait...
Still applies, KB 820835
From the MS CSS engineers
Paul Randall's "In recovery" blog (can't get in to refine it)
gbn
2009-11-15 17:08:38
A:
Chances are that you have a database that was being restored and that process wasn't finished. Try doing the following:
RESTORE DATABASE mydb WITH RECOVERY
(that's the entire command - no other options needed)
Greg Low
2009-11-16 10:25:31