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

  • I assume you have autogrow enabled on your log file. Check the default trace to see when it grew, that can help establishing a timeframe of when the log bloat started, and hopefully mostly occurred:

    Reviewing AutoGrow events from the default trace by Aaron Bertrand

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