• Jeff Moden (7/21/2014)


    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.

    If you take a log backup to different drive or delete it the same is true, so I don't see your point.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉