In recovery message along the database name

  • I am using SQL server 2008 R2 express. Sometimes i see that only some database show "(In recovery)" along its name. After sometime it becomes proper. But again some day it again become in recovery mode. I have not restored that database. Why this In recovery message repeatedly?

    I have already seen so many forum links and article saying about restoring,on going transaction etc causing this error. But that was not my case. So is there any reason for this?

    Thank you

  • Service stop start? Each time SQL starts up it needs to recover the database to ensure it is transactionally correct.

  • Thnk u anthony for your reply

    But i found that this in recovery message not only comes after restarting the sql server. Sometime it comes and again goes off after 10 minutes..!!

  • What are the settings of the database(s) in question?

    Auto close on?

  • Yes, Auto close is set to true.The recovery model is full.

  • That will cause it to happen.

    Auto close will switch the database to offline after the last person disconnects, then when you need access it sets online which forces recovery.

    I would switch the option to false.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply