Why is my transaction log full?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Gail Shaw » Why is my transaction log full?

Add to briefcase

77 posts, Page 1 of 8

1 2 3 4 5 »»»

Why is my transaction log full?

Expand / Collapse

Author

Message

Posted Sunday, February 20, 2011 11:09 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 37,687, Visits: 29,945

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

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1066878

Posted Monday, February 21, 2011 1:12 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370, Visits: 6,468

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

Smile

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1066954

mohammed moinudheen

Posted Monday, February 21, 2011 1:28 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170, Visits: 3,582

Thank you Gail, the article is superb

Mohammed Moinudheen

Post #1066960

Posted Monday, February 21, 2011 1:30 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 6,861, Visits: 8,048

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?

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

w00t

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

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

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Hehe

Post #1066961

Posted Monday, February 21, 2011 6:20 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, May 18, 2013 7:23 AM
Points: 141, Visits: 372

great articles! It connected all dots and very useful

Post #1067070

Posted Monday, February 21, 2011 6:50 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:10 AM
Points: 485, Visits: 1,568

Great article Gail. Thank you.

Post #1067082

Posted Monday, February 21, 2011 7:35 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:32 PM
Points: 3,575, Visits: 5,115

Nicely done.

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

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

BigGrin

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail

Post #1067092

Posted Monday, February 21, 2011 8:21 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 1,558, Visits: 1,396

Great article Gail!!

My blog: SQL Soldier
Twitter: @SQLSoldier
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring

Post #1067125

Posted Monday, February 21, 2011 8:27 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:45 AM
Points: 1,786, Visits: 1,006

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

Post #1067130

Posted Monday, February 21, 2011 10:19 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:39 AM
Points: 2,551, Visits: 7,205

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

Post #1067191

« Prev Topic | Next Topic »

Add to briefcase

77 posts, Page 1 of 8

1 2 3 4 5 »»»

Permissions

Expand / Collapse