March 31, 2009 at 1:39 pm
i have a sql 2005 active/passive cluster at off-site location. In looking the the sql log directory I see a trace file being create at 10:00 AM every day now for the last 3 days on this server. Nothing in scheduled tasks, or sql jobs. it creates a trace file with the name
log_399,log_400 etc. It stops at 20,480 bytes. Any place else to look?
March 31, 2009 at 1:52 pm
di you look into windows Sheduler or put in place trace to view who start trace whith this filter
exec sp_trace_setstatus
March 31, 2009 at 1:55 pm
Nothing in scheduler, all is being captured is creation and delete of objects, most of them in tempdb
March 31, 2009 at 2:00 pm
look this
http://msdn.microsoft.com/en-us/library/ms175513(SQL.90).aspx
March 31, 2009 at 2:01 pm
sebastien piche (3/31/2009)
di you look into windows Sheduler or put in place trace to view who start trace whith this filterexec sp_trace_setstatus
Reminds me of the default trace that SQL 2005 has. This is an Audit trace on Objects.
-Roy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply