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 9:01 am
#1704559
OK, then use DBCC INPUTBUFFER to find out whether blocking or blocked process are doing anything on the PEP database. You'll need to resolve the blocking in order for the blocked process to complete.
John