Home Forums SQL Server 2005 Backups tran log backup confused 2.5gb log file but 70gb log backup size RE: tran log backup confused 2.5gb log file but 70gb log backup size

  • June 9, 2012 at 6:21 pm

    #1499063

    Here is another article for your reference that helps explains why bulk logged is not reducing the size of your tlog backups:

    Using Bulk Logged recovery model for Bulk Operations will reduce the size of Transaction log backups – Myths and Truths

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato