Search

Tuesday, May 13, 2014

Stop logging successful backup of databases in SQL Server error log

If you want to stop all database successful backups message in error log than use below DBCC command. This will not record successful backup message in error log but store all other message 

DBCC TRACEON(3226,-1)

Now if you want to record both success and failure backup databases entry in SQL Server error log, than run below DBCC command. 
By default SQL Server log you can see both success and failure backup entries.

DBCC TRACEOFF(3226,-1)

No comments:

Post a Comment