Bulk Logged Log Shipping and oversized log backups
We are using the bulk-logged recovery model on a fairly large database (200GB). When performing database maintenance, the database log file size becomes approx 1.7GB. However, the backup created by SQL Backup is of a 60GB log (compressed to 9.7GB). Can anyone explain the reason for this and where the 60Gb comes from?