April 30, 2009 at 7:37 am
Hi, I have a problem with a Sql Express 2008. There are lots of audittrace files (*.trc) and I have no idea how to stop the trace which is writing these files.
I was surfing the net for things that could help but I found only information regarding Sql 2005. There seem the files to be smaller (not 200 MB) and there seems to be a limit of the files written.
If I cannot stop that trace, how can I limit the size of the files and the number of files stored on the disk?
I tried to stop the trace by calling "exec sp_trace_setstatus 1,0" but the result is always an error telling me I have no right to start (even when I'm "sa").
Thanks in advance!
Axel
April 30, 2009 at 7:46 am
What does fn_trace_getinfo tell you about the trace?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 30, 2009 at 7:56 am
April 30, 2009 at 8:05 am
Upps, that's the place where I didn't look. It's right - under properties the "C2 auditing" was enabled.
I was going crazy because all tries with exec sp_configure... ended up with errors.
Ok, thanks alot!
May 3, 2009 at 4:21 am
a.bommersbach (4/30/2009)
Upps, that's the place where I didn't look. It's right - under properties the "C2 auditing" was enabled.I was going crazy because all tries with exec sp_configure... ended up with errors.
Ok, thanks alot!
As allways every where in this forum you are welcomed! 😎
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply