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

  • February 3, 2009 at 7:18 am

    #937104

    Arun (2/3/2009)

    I am able to take full backup in my production server using the WITH COPY_ONLY option now. Also the log shipping is working fine.

    The only time the COPY_ONLY option is necessary is if you are doing differential backups as without that a full backup will reset the differential base.

    Full backups never break the log chain.

    Are you doing differential backups?

    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