InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 02:23:59 GMT20http://www.sqlservercentral.com/Forums/Topic1407752-391-1.aspxThat 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.Wed, 16 Jan 2013 05:39:02 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1407752-391-1.aspxYes, Auto close is set to true.The recovery model is full.Wed, 16 Jan 2013 05:37:58 GMT IT researcherhttp://www.sqlservercentral.com/Forums/Topic1407752-391-1.aspxWhat are the settings of the database(s) in question?Auto close on?Wed, 16 Jan 2013 05:30:40 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1407752-391-1.aspxThnk u anthony for your replyBut 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..!!Wed, 16 Jan 2013 05:28:21 GMT IT researcherhttp://www.sqlservercentral.com/Forums/Topic1407752-391-1.aspxService stop start? Each time SQL starts up it needs to recover the database to ensure it is transactionally correct.Wed, 16 Jan 2013 05:04:36 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1407752-391-1.aspxI 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 youWed, 16 Jan 2013 05:03:40 GMT IT researcher