Post reply

Administration

  • March 10, 2010 at 6:41 am

    #137594

    Hi Ever Body,

    How to control my Transaction log, because Transaction log increase very fast.

    Please share with your knowledge regarding this issue.

    Regards

    Subbarayudu

  • March 10, 2010 at 6:45 am

    #1131329

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

    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

  • March 10, 2010 at 7:36 am

    #1131401

    subbarayudu, you seem to have an awful lot of "simple questions" that can easily be found by using the SEARCH feature on this site.... Besides that, BOL has a wealth of information as well...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • March 10, 2010 at 8:16 am

    #1131438

    To Control transaction log size you should take care following things=>

    1) Dont keep the transactions open for longer time

    2) schedule frequent transaction log backup

    3) Schedule the index rebuild/defrag activities during non-peak hours

    4) do the insertion/updation/deletion batchwise

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

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