Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My SQL Server 2000 logs show that the server performed an automatic recovery on several of our databases. The logs do not mention any errors found. Could I have corrupt or lost data?

share|improve this question

migrated from Aug 3 '11 at 18:38

This question came from our site for professional and enthusiast programmers.

On start up? This always happens. On when DB is brought "online" – gbn Aug 3 '11 at 13:38
@Mitch Wheat, you are right, I just voted to migrate my own question ;) – mikerobi Aug 3 '11 at 14:08
@gbn, thanks, I didn't know it did that at startup, answers my question. This is what happens when a programmer is force to moonlight as a DBA. Put that in an answer and I will accept it. – mikerobi Aug 3 '11 at 14:17
up vote 0 down vote accepted

This happens automatically when

  • SQL Server starts
  • you attach a DB
  • bringing a database it online
  • ...

Nothing to worry about.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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