In recovery message along the database name

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » In recovery message along the database name

In recovery message along the database name

Rate Topic

Display Mode

Topic Options

Author

Message

IT researcher

Posted Wednesday, January 16, 2013 5:03 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:51 AM
Points: 183, Visits: 947

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

Post #1407752

anthony.green

Posted Wednesday, January 16, 2013 5:04 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1407756

IT researcher

Posted Wednesday, January 16, 2013 5:28 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:51 AM
Points: 183, Visits: 947

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..!!

Post #1407772

anthony.green

Posted Wednesday, January 16, 2013 5:30 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

Auto close on?

Post #1407773

IT researcher

Posted Wednesday, January 16, 2013 5:37 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:51 AM
Points: 183, Visits: 947

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

Post #1407780

anthony.green

Posted Wednesday, January 16, 2013 5:39 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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.

Post #1407782

« Prev Topic | Next Topic »

Permissions