I'm following up on this Why is my SQL Log File Huge? article.
Looking at the disk usage report, the transaction log space use is practically zero. It shows 99.1% unused.
It is schedule to backup the log every hour for 24hours/day. Every hourly trn file is quite small but there is one backup at round 2AM that is close to the actual database data file size.
If I schedule the hourly log backup from 3AM to the next 1AM, then the next big trn file is 4AM.
If I scheduled the log backup from 4AM to 12AM then the next large trn file is 5AM.
If I schedule the hourly log backup from 12AM to 11:59:59PM then the next large trn file is 2AM.
The pattern seems to be that whatever the first of the next day backup, that trn file will be large.
The recovery mode is set to full. The log is set to 5MB autogrowth and max out at 2TB. I've also tried the Monitoring SQL Server database transaction log space to track the log space used at every hour. At every hour the log spaced used was never bigger than 99MB and most are .8MB in size.
Help is much appreciated!