October 27, 2009 at 8:09 am
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
October 27, 2009 at 8:33 am
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.
October 27, 2009 at 8:36 am
Thanks Steve. I thought so, but just wanted to check anyway.
I love your editorials. I look forward to reading them every day!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply