Why is my transaction log full?

  • Gail Shaw

    SSC Guru

    Points: 1004474

    Comments posted to this topic are about the item Why is my transaction log full?

    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
  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Great article! A good reference point for a constant recurring question in the Administration forums. 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • M&M

    SSC-Insane

    Points: 21699

    Thank you Gail, the article is superb

    M&M

  • Johan Bijnens

    SSC Guru

    Points: 134280

    Another ref to put in the "must read" section !

    Very good job !

    Is there already a "sql server db logs / recovery models " section in SSC Stairways[/url]?

    Johan


    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt ?

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me[/url] :alien: but most of the time this is me :hehe:

  • GNUZEN

    SSC Veteran

    Points: 202

    great articles! It connected all dots and very useful

  • Geoff A

    SSChampion

    Points: 11417

    Great article Gail. Thank you.

  • TheSQLGuru

    SSC Guru

    Points: 134017

    Nicely done.

    "...for correcting grammar errors, illogical sentences and an appalling dearth of punctuation."

    Those things are vastly overrated in technical articles anyway Gail! 😀

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • Robert Davis

    One Orange Chip

    Points: 28027

    Great article Gail!!


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • Abi Chapagai

    SSCrazy

    Points: 2666

    Great article Gail. Thank you for the effort to share this with us.

  • homebrew01

    SSC Guru

    Points: 55163

    Should probably be a "sticky" at the top of the various Admin forums.

  • Abi Chapagai

    SSCrazy

    Points: 2666

    I like the idea!

  • Ron McCullough

    SSC Guru

    Points: 63877

    Let me add my thoughts great article and thanks for the code examples.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Slick84

    SSCertifiable

    Points: 5602

    Great article, great reading.

    Now.. how can I manually activate/deactivate VLF's within a transaction log?

    Thanks,

    S

    --
    :hehe:

  • Gail Shaw

    SSC Guru

    Points: 1004474

    Slick84 (2/21/2011)


    Now.. how can I manually activate/deactivate VLF's within a transaction log?

    You can't. What are you trying to do?

    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
  • Gail Shaw

    SSC Guru

    Points: 1004474

    Thanks everyone. Glad you're enjoying it.

    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 15 posts - 1 through 15 (of 77 total)

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