These are really useful trace flags :
Stop logging all successful backups in your SQL Server error logs :
DBCC TRACEON(3226,-1)
Capture deadlocks in SQL Server error logs :
DBCC TRACEON(1222,-1)
These are really useful trace flags :
Stop logging all successful backups in your SQL Server error logs :
DBCC TRACEON(3226,-1)
Capture deadlocks in SQL Server error logs :
DBCC TRACEON(1222,-1)