Home Forums SQL Server 2008 SQL Server 2008 Administration Backing up a DB with log shipping turned on RE: Backing up a DB with log shipping turned on

  • July 21, 2014 at 12:12 pm

    #1731141

    GilaMonster (7/16/2014)

    Steve Jones - SSC Editor (7/16/2014)

    Yes. I believe you can use copy only, which avoids this

    Full backups do not break the log chain. Copy only on full backups is solely to avoid resetting the differential base.

    Ahh, sorry, was thinking you mentioned extra log backups, which are problematic.

    Fulls don't matter, as Gail mentioned