debugsqlMajor
Does SQL Server ever delete old error log files?
Viewed 0 times
errordeletelogsqlfilesdoesservereverold
Problem
I know I can cycle the current error log easily by running sp_cycle_errorlog, but I'm wondering if SQL Server will ever delete the old/archived error log files at all. Can't seem to find an answer to this anywhere...
Solution
In
SQL Server Management Studio, in Object Explorer > Management, there is a setting if you right click on SQL Server Logs and select Configure. You can specify how many log files you want to keep. Once it reaches that number it will start removing the old ones.Context
StackExchange Database Administrators Q#81388, answer score: 23
Revisions (0)
No revisions yet.