CODEWITHSUNDEEP
sqlsql-serverrecovery
EightyOne Unite
EightyOne Unite

Reputation: 11795

SQL Server 2005 Database 'In Recovery'

I restored a 35Gb database on my dev machine yesterday and it was all going fine until this morning when my client app couldn't connect. So I opened SQL Management Studio to find the database 'In Recovery'.

I don't know a huge amount about this other than it is usually something to do with uncommitted transactions. Now since i know there aren't any uncommitted transactions it must be something else. So first off, I'd like to know under what conditions this can happen. Secondly, while this is going on I can't work so if there are any ways of either stopping the recovery, speeding it up or at least finding roughly how long it's gonna be that would help.

Upvotes: 11

Views: 35868

Answers (2)

Julian Jelfs
Julian Jelfs

Reputation: 473

You can find out how long it's going to take by looking in the event viewer. In the Application section on the Windows Logs you should get information messages from MSSQLSERVER with EventID 3450 telling you what it's up to. Something like:

Recovery of database 'XYZ' is 10% complete (approximately 123456 seconds remain) etc etc

I'm afraid I don't know how to stop it (yet).

Upvotes: 11

user114600
user114600

Reputation:

Do not shut down SQL while recovery is in progress. Let it finish. Check the error logs. If it doesn't finish, restore from backup.

Upvotes: 14

Related Questions