Post reply

Why is my transaction log full?

  • February 20, 2011 at 11:09 am

    #234036

    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

  • February 21, 2011 at 1:12 am

    #1289303

    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

  • February 21, 2011 at 1:28 am

    #1289308

    Thank you Gail, the article is superb

    M&M

  • February 21, 2011 at 1:30 am

    #1289309

    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

  • February 21, 2011 at 6:20 am

    #1289398

    great articles! It connected all dots and very useful

  • February 21, 2011 at 6:50 am

    #1289408

    Great article Gail. Thank you.

  • February 21, 2011 at 7:35 am

    #1289417

    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

  • February 21, 2011 at 8:21 am

    #1289445

    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]

  • February 21, 2011 at 8:27 am

    #1289449

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

  • February 21, 2011 at 10:19 am

    #1289496

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

  • February 21, 2011 at 10:26 am

    #1289499

    I like the idea!

  • February 21, 2011 at 12:33 pm

    #1289564

    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]

  • February 21, 2011 at 1:03 pm

    #1289581

    Great article, great reading.

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

    Thanks,

    S

    --
    :hehe:

  • February 21, 2011 at 1:23 pm

    #1289592

    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

  • February 21, 2011 at 1:25 pm

    #1289594

    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 76 total)

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