Transaction logs are big

Question

Post reply

Transaction logs are big

Krasavita

SSC-Insane

Points: 23138
More actions
October 26, 2009 at 9:55 am

#98131

My logs are bigger than data, how can I make them smaller, I have 10% left of ree spasa on the drive. Thank you

Viewing 3 posts - 1 through 2 (of 2 total)

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

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

What is your bakup/recovery mode ... Simple/Full ... do you take periodic log backups? How frequent are your backups?

In addition to Gail Shaws' excellent article you might also read these articles by Paul Randal

http://www.sqlskills.com/BLOGS/PAUL/post/How-do-checkpoints-work.aspx

http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-More-on-the-circular-nature-of-the-log.aspx

http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx

edited 12:31 PM

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]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Please read through this - Managing Transaction Logs[/url]

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