Post reply

Trace file not accessible

  • November 11, 2010 at 5:34 am

    #388209

    Hi,

    I created a trace file using server side trace and ran it for 3 hours. It has stopped execution. Sys.traces doesn't show information about that trace however it seems some process is still using that file. I am unable to copy/rename it.

    If i create a trace file using profiler(for few seconds) then it's accessible. I have admin rights on the server.

    Pls help!!


    Pradeep Singh

  • November 11, 2010 at 5:51 am

    #1249420

    select * from fn_trace_getinfo(NULL)

    --will return all the current running traces and some additional info (very similar to above)

    maybe the wrong trace was stopped...

    If you right-click on My Computer, go to Manage, then under Shared Folders, Open Files. This will show an open files on your machine (or server) and the type of action (Read/Write) to the files.

  • November 11, 2010 at 5:56 am

    #1249424

    Thanks for the reply.

    I had noted the trace id which was 2.

    currently only one trace is running with an id of 1 which is the default trace.

    Any idea what else could be holding the files? I also logged off the server and logged in again to make sure no process running under my id is locking them up.


    Pradeep Singh

  • November 11, 2010 at 5:57 am

    #1249427

    more added to my original post 🙂

  • November 11, 2010 at 5:59 am

    #1249428

    Hmmm Thanks. I dont hv access to see that. Will need help from wintel guys on this.


    Pradeep Singh

  • November 11, 2010 at 6:02 am

    #1249431

    only way I know of, to see what files are open, by who and the type of "lock".

  • November 11, 2010 at 8:25 am

    #1249531

    Wintel guys copied the file to dev server. They didn't tell what the issue was:ermm:


    Pradeep Singh

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply