Hello all. I have setup DB backup jobs (including Full, Differential and log) on SQL Server 2008 R2 with SP3 - OD (which is our production physical server) to run every 20 minutes through maintenance plan wizard. The concern is regarding the log file backups which is getting heavier in size (from 2 MB to 2 GB sometimes) than the normal. The same job has been setup in another instance but there the log file is only 200 KB to 300 KB. There is only 1 database (Full-recovery) in this server and it is connected to an application doing OLTP (very I/O intensive). I have set the log backups with compression. Although we have enough space to accommodate the log files in the shared drive, but this seems unusual. What is that I am doing wrong? Can anyone assist? Please let me know in case you need additional info. Thank you!
