Transaction Log Backup Cleaning

backuptransaction-log

If you back up your transaction log every hour through a maintenance plan, why does your log file continue to grow? I would think the system would delete or shrink the log after the backup. Is this something I want to do?

Best Answer

  1. Because the size of it is not big enough to handle the size of the transactions every hour.

or

  1. Something is preventing the log from getting cleared after the log backup completes. Check the log_reuse_wait_desc column in master.sys.databases to see why it isn't clearing out.

Consider backing up the transaction logs more frequently than hourly. I recommend every 1-5 minutes.