14

I got so error:

Database 'MyDb' is being recovered. Waiting until recovery is finished.

I have had a critical operation at that time.

What is the cause of this situation? And how can it be avoided?

1 Answer 1

24

Crash recovery is running on 'MyDb'. Possible causes:

  • The SQL Server service was restarted manually, due to a crash or a server stop/start.
  • A severe error in the database caused the database to be shut down and recovered.
  • Recovery was initiated deliberately by someone executing a RESTORE WITH RECOVERY.
  • The Auto-Close option is set, causing the database to shut down when the last user exits and run recovery to restart when the next connects.

If recovery is taking a long time to complete and there doesn't appear to be any activity you may need to restore from backups. If you're feeling brave you should start reading everything you can find about repairing/recovering suspect databases.

More information on what happened before the database ended up in this state would make for better answers e.g. what actions you carried out, what errors are in the SQL error log etc.

1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.