August 10, 2017 at 11:04 am
Hi there! We have a trace going and realized that it is basically turning itself off once it hits the max file size and file number count. Is there an automated way to make the trace just start overwriting the oldest records? Or do I have to create some sort of cleanup job to go delete one of the files when it hits the max file size?
August 10, 2017 at 11:59 am
Something like that can be achieved, by using Rollover option, and using parameter @filecount while using the proc sp_trace_create. It will basically delete the oldest file if the maximum number of rollover files has been reached. You can find more here by Kalen Delaney:
August 10, 2017 at 12:04 pm
Odd I have that set though... I have the max file size set, the number of rollover files set to 2... and the second parameter is set to 6.
August 10, 2017 at 12:51 pm
amy26 - Thursday, August 10, 2017 12:04 PMOdd I have that set though... I have the max file size set, the number of rollover files set to 2... and the second parameter is set to 6.
If it's set correctly, it could be that the file is in use - it won't be deleted if that is the case. Maybe try to set the trace files to a folder that can be excluded by antivirus.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply