Modifying Default Trace

• cathy.baker

  Hall of Fame

  Points: 3412

  More actions

  October 27, 2009 at 8:09 am

  #211463

  Is there are way to modify the default trace in SQL Server? I have a data warehouse that is being replicated and the trace file rolls over every 45 minutes because it reaches the maximum size. I would like to do ONE of the following (whichever makes the most sense):

  1. Change the default size of the trace file before rollover.

  2. Change the retention period of the trace file(s).

  3. Remove the trace events related to the replication.

  If not, I guess I'll have to copy the files to a backup area to retain more than 4 hours worth.

  Thanks,

  Cathy

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738277

  More actions

  October 27, 2009 at 8:33 am

  #1071245

  Nope, can't modify it: http://blogs.technet.com/beatrice/archive/2008/04/29/sql-server-default-trace.aspx

  But you can set up your own trace that includes the events and settings you need.

• cathy.baker

  Hall of Fame

  Points: 3412

  More actions

  October 27, 2009 at 8:36 am

  #1071249

  Thanks Steve. I thought so, but just wanted to check anyway.

  I love your editorials. I look forward to reading them every day!