Post reply

How do I get the ideal size of the transaction log file

  • September 22, 2011 at 11:06 am

    #248579

    Right now my transaction log file is 512457 mb and only 2% is used.

    How do I determine what size I should change the log file so I don't waste space?

    The database is 1205424 MB.

    Thanks

  • September 22, 2011 at 11:11 am

    #1385330

    So log size à 512 GB and db size @ 1.2 TB?

    This seems a little overkill.

    What you can do is check the log backup history size and see the max value and the "normal" max value. I say normal because sometimes there's a screw up that blows up something and that number just can't happen again.

  • September 22, 2011 at 1:23 pm

    #1385395

    and when you do resize it, shrink it right down and manually grow it in 8GB chunks to get sensible sized VLFs.

    presuming here you will need a reasonably large log file. I always work in multiples of 64MB, 1Gb or 8GB.

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply