January 29, 2009 at 1:51 pm
Hello all,
I manually created a trace file to capture some deadlock events. I am now through working with the trace file and have set the trace status to 0 using "sp_trace_setstatus". No matter what I do I cannot delete the trace files that were generated. Everytime I attempt to delete the trace files, it says that the files are currently being used by another person or applications. I would appreciate any help deleting the files. I am guessing that if I stop sql server it will let me delete the files, however, I would rather not stop the machine as it needs to be up 24/7. Thank you in advance.
January 29, 2009 at 2:02 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic646379-149-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2009 at 2:17 pm
I knew someone would be quick to jump on that. I did not cross post. I created the post in the wrong forum so created a new one in a more appropriate forum.
January 29, 2009 at 2:31 pm
In the future, if you do that, please edit the incorrect post to point to the new one, then anyone who reads it knows that it's not to be replied to. Or report the post to the mod and ask him to move it, instead of creating a new one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 29, 2009 at 3:34 pm
tgarland sent me a note. I was slow to act, but I'm closing this thread. Anyone reading this, please use the link to hit the open one.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply