How to stop logging messages in error log

• G Sunny

  SSC Eights!

  Points: 988

  More actions

  July 27, 2018 at 9:14 am

  #354786

  

  How do i stop logging unwanted messages in SQL error logs, I enabled DBCC TRACEON (3226,-1) to avoid logging successful backups, likewise is there any other trace flags or any message id's to disable in msdb.dbo.sp_altermessage
  Thanks in Advance

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  July 27, 2018 at 9:35 am

  #1999262

  I don't think you can. I asked this myself a few months ago for the same reason. It's so irritating!

• July 27, 2018 at 10:40 am

  This was removed by the editor as SPAM