Sql server 2012 tranction log keeps growing
Posted on 2014-10-01
I am having an issue with the size on the transaction log on one of my databases. The database is around 90 gigs and the transaction log is about 110 gigs. I have a maintenance plan that runs nightly full backup 7 days a week and hourly transaction log backups 24/7. About two months ago I tried the shrink the log file. I first did a full backup and then a transaction log backup. I then shrank the log file down to 30 gigs. After a few minutes I started seeing the log file growing again. It went back up to 80 gigs. I am not a dba, but it was my understanding that if I am doing regular transaction log backups, it should keep the size of the log file small. Does anyone know why the log file should be growing?