Post reply

Doubt on transaction log backup

  • November 13, 2010 at 7:50 am

    #143543

    When we take a transaction log backup, the log file gets truncated.

    When we use the backup log with truncate only option, log file gets truncated.

    But why is it that when we use the second option, we need to take full database backup again and not

    in the first option.

    M&M

  • November 13, 2010 at 8:38 am

    #1250362

    Because the second says 'truncate the log without backing it up, discard all inactive log records'. Since the log records have been discarded (not backed up), the log chain is broken and a full or diff backup is required to restart the log chain again.

    Please read through this - Managing Transaction Logs[/url]

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 15, 2010 at 1:21 am

    #1250562

    Thank you for clarifying.

    M&M

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

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