Post reply

Log Shipping -Shrinking log file WITH TRUNCATE option

  • June 14, 2018 at 2:49 am

    #369870

    Good Morning Experts,

    In Log Shipping, it is said that when shrinking the log file , we should not use WITH TRUNCATE option because it will break Log Shipping. I am curious to know why will it break Log Shipping. What happens actually? Thanks in advance

  • June 14, 2018 at 3:12 am

    #1993956

    I suppose that you have been told to avoid taking backups with TRUNCATE_ONLY, because they break the log chain. Shrinking the log is a totally different operation, that (while potentially negative) has no impact on the log chain.
    The two commands are sometimes run together because sometimes users want to rapidly reclaim disk space by throwing away the contents of the log (backup with truncate_only) and shrinking the log.

    -- Gianluca Sartori

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply