SCM Services - Configure SQL Server Error Logs
This topic describes how to view or modify the way SQL Server error logs are recycled.
To open the Configure SQL Server Error Logs dialog box
In Object Explorer, expand the instance of SQL Server, expand Management, right-click SQL Server Logs, and then click Configure.
In the Configure SQL Server Error Logs dialog box, choose from the following options.
a. Log files count
Limit the number of the error log files before they are recycled
Check to limit the number of error logs created before they are recycled. A new error log is created each time an instance of SQL Server is started. SQL Server retains backups of the previous six logs, unless you check this option, and specify a different maximum number of error log files below.
Maximum number of error log files
Specify the maximum number of archived error log files created before they are recycled. The default is 6, not including the current one. This value determines the number of previous backup logs that SQL Server retains before recycling them.
b. Log file size
Maximum size for error log file in KB
You can set the size amount of each file in KB. If you leave it at 0 the log size is unlimited.