• Martin Stephenson (12/6/2012)


    If I set up log shipping, the translogs are applied to the target database, if the source gets a new full backup, doesnt that break the log chain for transaction log backups and therefore stop you applying it to the target database?

    No, what it does do is to reset the differential backup chain by incrementing the differential base LSN.

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

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