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