Post reply

Forgot to do RECOVERY on restore of last transaction log.

  • March 2, 2009 at 9:14 am

    #200834

    Hi All

    I am testing our Restore procedures and I forgot to specify RECOVERY when I restored the final transaction log file. Not sure what to so next.

    Thanks

    Craig

  • March 2, 2009 at 9:22 am

    #951921

    Restore Database < DB Name > WITH RECOVERY

    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

  • March 2, 2009 at 9:57 am

    #951950

    FWIW, I'd consider this the way to do things. Always restore with NORECOVERY and then once you're sure you're done, run the statement Gail has listed above.

  • March 2, 2009 at 12:58 pm

    #952058

    Steve Jones - Editor (3/2/2009)

    Always restore with NORECOVERY and then once you're sure you're done, run the statement Gail has listed above.

    Agreed. Much safer than putting the WITH RECOVERY flag on the wrong log backup and having to start again from scratch (had that happen once. Meant I went home 4am instead of midnight)

    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

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

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