Post reply

Delete Trace files

  • December 17, 2010 at 1:44 am

    #141795

    Hi

    I would like to delete the default trace files created by SQL Server 2005.

    When ever i try to delete it says file is in use. I cross checked that the file is 2 day old and the trace is being written to new file.

    No sql statement or query is running is using the trace file.

    What can be the other ways to check who is using the file.

    I cant install tools to check who is using the file. neither can i restart the sqlserver..

    Any good ideas.

  • December 17, 2010 at 6:50 am

    #1264036

    You shouldn't delete default trace files. SQL Server overwrites oldest file when required, so you shouldn't worry that your disk will fill out with old trace files. If you monitor for some time number of trace files you will notice that this is always the same number of trace files.

  • December 18, 2010 at 1:24 am

    #1264342

    To check which process is using a file, you can use the command line utility Handle. Does not require any installation of files rather an .exe file and administrative privilege.

Viewing 3 posts - 1 through 2 (of 2 total)

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