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

  • If your database is heavily indexed, and you are rebuilding indexes frequently, this could account for the large log backups. This would especially be true if you have a small fill factor on some indexes, and its causing lots of page splits.

    If that is the case, read:

    David Lathrop
    DBA
    WA Dept of Health