up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
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
feedback

migrated from stackoverflow.com Aug 3 '11 at 18:38

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

1 Answer

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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