Home Forums SQL Server 2005 Backups Backup and transaction log RE: Backup and transaction log

  • May 8, 2009 at 2:16 am

    #990915

    GilaMonster (5/8/2009)

    Gianluca Sartori (5/8/2009)

    Exactly: the transaction log backup is taken from the last backup, either full or tlog.

    Not quite.

    Log backups contain the log records since the previous log backup. Full and diff backups do not truncate the transaction log. The only time a log backup will contain log records since a full, is if that's the first log backup done after setting the DB into full/bulk logged recovery.

    Thanks Gail, once again you're right. (Fortunately) I don't have to play with backup/restore that much, so I tend to forget important things like this.

    -- Gianluca Sartori