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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy