November 20, 2009 at 2:42 pm
HI,
I know in sql 2005 the default trace file names are in the form of log_##.trc. I am seeing some trace files in the same directory as the default trace file with different names such as: 291-45486dm5wptrace_216.trc Can someone tell me how this kind of trace file gets created and where from. I'm the only dba that would be doing any manual traces. I tried opening profiler and running a simple trace and stopped it. Went to the directory of the instance of sql server I ran the trace against and no new trace file. So I'm confused how these strange trace files are getting created.
Juanitas
November 20, 2009 at 5:43 pm
Run the following to find out if other traces are running.
select * from fn_trace_getinfo(0)
Property 2 will tell you where the files are being written. Is the trace file you are looking at still active or is it from an old trace that maybe off now?
November 23, 2009 at 8:03 am
fn_trace_getinfo will give you the information, but querying sys.traces actually gives you more information in a more readable format (you don't have to know what the property numbers mean because you get the data in a table with real column names).
You don't have C2 or Common Criteria auditing turned on do you?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply