Why is my transaction log full?

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

  • Thank you Gail, the article is superb

    M&M

  • 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

    Learn to play, play to learn !

    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 but most of the time this is me

  • great articles! It connected all dots and very useful

  • Great article Gail. Thank you.

  • 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

  • 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]

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

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

  • I like the idea!

  • 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]

  • Great article, great reading.

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

    Thanks,

    S

    --
    :hehe:

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