Home Forums SQL Server 2005 SQL Server 2005 Strategies Need strategy for disaster recovery RE: Need strategy for disaster recovery

  • February 4, 2009 at 9:30 am

    #938108

    Arun (2/4/2009)

    I was thinking that log shipping is just an automation of the normal transaction log backups and restores which we normally perform. but it didnt fail even after i took full backups, log backups and even diff backups in the source server.

    If you take a log backup and don't ship it, you will have a problem. No log backups past that point will restore, saying there are LSNs missing.

    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