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

  • July 16, 2012 at 1:10 pm

    #1513266

    lawson2305 (7/16/2012)

    ok I just don't get it. They are back up to 66GB again.

    I run a tran backup and shrink every day. I append the backup daily except for Saturday I do a overwrite.

    The tran backup is now 66 GB and the ldf file is 66GB with 99% available free space.

    Have you read the link supplied to you by Gail Shaw?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉