Export (0) Print
Expand All

Configure SQL Server Error Logs (General Page)

Use this page to view or modify the way SQL Server error logs are recycled.

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 error log files created before they are recycled. The default is 6, which is the number of previous backup logs SQL Server retains before recycling them.

To open the Configure SQL Server Error Logs dialog box

  • In Object Explorer, expand your server, expand Management, right-click SQL Server Logs, and then click Configure.

Community Additions

ADD
Show:
© 2014 Microsoft