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:39 am
#1704545
Now i am confused! 18th October 2014? You need to disable DBCC TIMEWARP. Was that the full output of sp_who2 that you posted? You're mostly interested in SPIDs above 50 - the others are system tasks.
John