Post reply

Database showing (Recovering) after reboot

  • March 30, 2007 at 11:02 am

    #172851

    I have a few large databases on a server.  After rebooting the server my database shows dbname(Recovering) in the Mgmnt Studio.  Can someone tell me what this means and why it is happening.  I sometimes have to wait up to five minutes for the database to fully come back on line. 

  • March 30, 2007 at 11:09 am

    #697900

    SQL Server is applying the changes stored in the transaction log.  Your transaction log is probably very large.  Are you dumping your transaction log on a regular basis?   It's possible, though unlikely, that the recovery interval option is set too high (take a look using sp_configure 'recovery')  You might also try to issue a "checkpoint" command on each database before doing the reboot. 

    Regards,

    Carlos

  • March 30, 2007 at 1:43 pm

    #697929

    Gary ... I see this all the time with my large databases.  Perfectly normal, especially if they are taken down just prior to a tran log backup.  I like Carlos's suggestions. 

    😎

  • April 2, 2007 at 8:42 am

    #698106

    Did this problem clear up or did it get set to Suspect?

    Live to Throw
    Throw to Live
    Will Summers

Viewing 4 posts - 1 through 3 (of 3 total)

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