Logs Not TRUNCATING SQL 2008R2

Question

Logs Not TRUNCATING SQL 2008R2

MostInterestingMan

SSCertifiable

Points: 6291
More actions
February 15, 2012 at 9:02 am

#250754

Hi,
My trans logs don't seem to be truncating and I'm not sure why. My recovery model is set to FULL per requirements and I'm taking nightly full backups and hourly log backups, however, the logs files are larger than the data files in some instances. My understanding is that the log backup should truncate the logs. Am I missing something?
Thanks
MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends

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

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

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

Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

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

MostInterestingMan SSCertifiable Points: 6291 More actions · Answer 2

GilaMonster (2/15/2012)
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

Thank You Gail. The post was very helpful.

MCTS: BI 2008, MCITP: BI 2008
Stay Thirsty My Friends