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)
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