Home Forums SQL Server 2005 SQL Server 2005 General Discussion 95 GB Transaction Log but Log Backups are much smaller RE: 95 GB Transaction Log but Log Backups are much smaller
John Mitchell-245523
SSC Guru
Points: 148809
More actions
April 9, 2014 at 8:05 am
#1704520
Karen
Your log won't be truncated until that transaction is complete. Do you have a long-running job or some other process that's been going for a while?
John