Delete Trace files

Question

Delete Trace files

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

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

magasvs SSCertifiable Points: 7660 More actions · Answer 1

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.

Psqldba SSC Journeyman Points: 84 More actions · Answer 2

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.