Configure SQL Server Error Logs

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

Configure SQL Server Error Logs

Use this dialog box to view or specify the following options.

Options

Limiting 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 Microsoft® SQL Server™ is started. Typically, 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 the error log files.

Specify the maximum number of error log files created before they are recycled. The default is six, which is the number of previous backup logs SQL Server retains before recycling them.

See Also

Using the SQL Server Agent Error Log