January 16, 2013 at 5:03 am
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
January 16, 2013 at 5:04 am
Service stop start? Each time SQL starts up it needs to recover the database to ensure it is transactionally correct.
January 16, 2013 at 5:28 am
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..!!
January 16, 2013 at 5:30 am
What are the settings of the database(s) in question?
Auto close on?
January 16, 2013 at 5:37 am
Yes, Auto close is set to true.The recovery model is full.
January 16, 2013 at 5:39 am
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