I've got a sql 2000 DB with a .mdf size just under 3GB. the log file is about 2GB at this time. Most of the hourly/daily log backups are very small, between 2.5MB down to as small as 140K when there's little to no activity. However, just after my data backup maintenance plan runs the translog backup file is closer to 2.5GB. This plan runs sunday evenings only and backs up the DB and also runs the 'Reorganize data...' step under Optimizations.
I also run a translog plan daily that backs up the Trans log only, once each business hour.
Occasionally this server runs a bit low on disk space, so I'd like to know if there's any adjustment I could make to either maintenance plan that might result in a smaller translog backup after the Reorg Data operation.
Thanks for any feedback!