Post reply

SQL 2008 Log Truncation

  • September 1, 2009 at 11:25 am

    #1047696

    Thanks again.

    If it is shrunk beyond the size it needs to be won't it just allocate more space?

  • September 1, 2009 at 11:43 am

    #1047708

    jeremym (9/1/2009)

    If it is shrunk beyond the size it needs to be won't it just allocate more space?

    Yes, and that will force transactions to wait while the log is expanded and the new space zeroed out.

    File grows are expensive, especially for the log that cannot use instant initialisation (which the data file can)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 4, 2009 at 3:24 pm

    #1088068

    The most efficient way to keep the log files from growing, is to do "Incremental" T-log backups (multiple times throughout the day.)

Viewing 3 posts - 16 through 17 (of 17 total)

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