Post reply

Transaction log growing very quickly Need to truncate it

  • March 7, 2012 at 6:08 pm

    #252725

    Hi

    Few days back i have loaded 100Million records twise. My data base hard drive started eating more observed that Transaction logs were eating physical memory. Transaction logs set to grow unlimited. How can I recover that physical memory...If I do any property changes to autotruncate or someother stull will that effect any of my existing database....

  • March 7, 2012 at 9:07 pm

    #1456343

    I believe your database is in FULL recovery model.

    Until you take log backup, transactions remain in the log and file keeps growing.

    Short term solution:

    1) Take t-log backup

    2) Shrink the log file

    There are good articles about managing transaction log. Please research them.

  • March 7, 2012 at 10:51 pm

    #1456350

    It might be better to change the recovery model to BULK Logged the next time you import large volumes of data

    Jayanth Kurup[/url]

  • March 8, 2012 at 4:13 am

    #1456431

    Please read through this - Managing Transaction Logs[/url]

    p.s. Large transaction log does not cause high memory usage.

    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

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

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