Why is my transaction log full?

Question

Why is my transaction log full?

Gail Shaw

SSC Guru

Points: 1004504
More actions
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

Viewing 15 posts - 1 through 15 (of 76 total)

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

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 1

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: 21700 More actions · Answer 2

M&M

SSC-Insane

Points: 21700

February 21, 2011 at 1:28 am

#1289308

Thank you Gail, the article is superb

M&M

Johan Bijnens SSC Guru Points: 135449 More actions · Answer 3

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

GNUZEN SSC Veteran Points: 202 More actions · Answer 4

great articles! It connected all dots and very useful

Geoff A SSChampion Points: 11511 More actions · Answer 5

Geoff A

SSChampion

Points: 11511

February 21, 2011 at 6:50 am

#1289408

Great article Gail. Thank you.

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 6

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 More actions · Answer 7

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 More actions · Answer 8

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

homebrew01 SSC Guru Points: 55549 More actions · Answer 9

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

Abi Chapagai SSCrazy Points: 2666 More actions · Answer 10

Abi Chapagai

SSCrazy

Points: 2666

February 21, 2011 at 10:26 am

#1289499

I like the idea!

Ron McCullough SSC Guru Points: 63877 More actions · Answer 11

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 More actions · Answer 12

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: 1004504 More actions · Answer 13

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: 1004504 More actions · Answer 14

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

Why is my transaction log full?

Cookies on SQLServerCentral