Troubleshoot odd large transaction log backups...
- by Tim
I have a SQL Server 2005 SP2 system with a single database that is 42gigs in size.
It is a modestly active database that sees on average 25 transactions per second.
The database is configured in Full recovery model and we perform transaction log backups every hour. However it seems to be pretty random at some point during the day the log…