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 10:51 pm

    #1731306

    Perry Whittle (7/21/2014)

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

    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

    They don't affect log backups but they do affect differential backups 😉

    Technically, I agree but if you do a full backup to a different drive or folder than where the backups are normally stored at (or even the same folder) and someone deletes it, I believe (haven't tried it in a very long time and don't remember for sure) that can screw up the GUI for doing a restore because MSDB still thinks the file exists.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)