Filtering Backup Info to the SQL Server Error LOg

• Bru Medishetty

  SSC-Insane

  Points: 23606

  More actions

  October 20, 2009 at 9:43 am

  #205802

  I have SQL Server 2005 Standard Edition.

  There is a maintenance Plan to backup Trans-Logs and it is running every quarter hour.

  The SQL Server Error Log is filled with the backup information of these and I want to get rid of it.

  I modified the Maintenance Plan and disabled the Logging, but still it is writing to the SQL Error Log.

  do I have to enable any Flag or any other suggestions where to configure this.

  Thanks in Advance

  ---

  Bru Medishetty

  Blog -- LearnSQLWithBru

  Join on Facebook Page Facebook.comLearnSQLWithBru

  Twitter -- BruMedishetty

• Bru Medishetty

  SSC-Insane

  Points: 23606

  More actions

  October 20, 2009 at 10:32 am

  #1068341

  Yeah I found it on the web.

  I need to enable the trace flag 3226.

  Thanks Sugesh for the Blog

  http://sugeshkr.blogspot.com/2009/01/introduction-to-sql-server-trace-flags_14.html

  ---

  Bru Medishetty

  Blog -- LearnSQLWithBru

  Join on Facebook Page Facebook.comLearnSQLWithBru

  Twitter -- BruMedishetty