Sample Header Ad - 728x90

SQL Default trace not deleting files above the max no of trace files

0 votes
0 answers
292 views
We have a Sql server 2016 Sp2. Noticed the trace file path D:\Data\MSSQL13.MSSQLSERVER\MSSQL\Log\log_298.trc is getting filled with trace files and the files are more than 2 months old. To my understanding the max number of trace files should be 5 and if that is the case why it is not deleting files above 5 max trace files. The only option for me is to disable the default trace. Please advice if there are settings where I can check or any other option I can implement to that the Log drive don't get filled up.
Asked by SQL_NoExpert (1117 rep)
Aug 2, 2023, 02:48 PM