• SQLRNNR (1/21/2014)


    GilaMonster (1/21/2014)


    praneethydba (1/21/2014)


    Still in Recovery. I am Panic.

    Be patient.

    The progress gets logged to the error log, check there for estimated time remaining, but note it's often on the low side

    Here is an article with a query to check the recovery process.

    http://jasonbrimhall.info/2012/06/04/database-in-recovery/

    This query can likely help ease some of the anxiety.

    I've seen the error log figure count down to about 10 minutes, then jump up to a few hours again. It's not reliable, it's an estimate.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass