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)
- Comment
- Reblog
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Cloud & SQLSailor 
Leave a comment