Lynn Pettis (8/21/2012)
MegaDBA (8/21/2012)
I would increase the time you take a log backup to let's say every 30 mins. And as Scott said, you should set the tLogs to grow in MB as oppossed to a percentage.
I will agree with changing the t-log to grow at a set size, but I would also size the t-log to a size that holds all the normal transaction activity plus a safety margin for unusual activity. Every time you wait for the log file to grow and initialize you are impacting server performance.
What Lynn said. I realized after I posted my comment that the sizes didn't make sense. It has an initial size of 29 gigs, right? But from you're screen shots, it looks like the backups are varying in size around 6-10 gigs. That doesn't make sense unless compression is in play here.