question

Vish_DBA avatar image
Vish_DBA asked

Maintenance Plan Log Backup File are heavier in size than normal.

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!

sql server 2008 r2transaction-logmaintenance-planslog-backup
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.