I don't think there are any long running transaction that time when maintenance is happening.Once the maintenance is over after 2 hrs, and if I run DBCC SQLPERF(Logspace), the used space is less than 1%. That means almost all space is free. Although I never checked the space after each transaction log backup.
John Mitchell-245523 (4/29/2013)
Maybe you've got an uncommitted transaction or something like that. How much free space is there in the log file after the index maintenance has finished and the log has been backed up?John
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.