Home Forums SQL Server 7,2000 Backups why weekly translog backup is so large RE: why weekly translog backup is so large
Lynn Pettis
SSC Guru
Points: 442467
More actions
November 13, 2012 at 6:12 pm
#1558707
Sounds like you are rebuilding indexes in your maintenance plan. Index rebuilds are a fully logged operation. Even if you switched to bulk logged recovery model the t-log backup would be large even though the t-log itself would be smaller.