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)?
SQL Server 2008 DB recovery: does it actually work
sql serversql-server-2008
Related Topic
- Sql-server – How to check if a column exists in a SQL Server table
- Sql-server – Check if table exists in SQL Server
- Sql – How to concatenate text from multiple rows into a single text string in SQL Server
- How to connect to local instance of SQL Server 2008 Express
- Sql-server – LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- Sql – How to UPDATE from a SELECT in SQL Server
- Sql – Rename column SQL Server 2008
- Sql – How to delete using INNER JOIN with SQL Server
Best Answer
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)