Skip to content

Increase Maximum Number Of Error Log Files


When a Microsoft SQL Server instance is started, it will create a new error log file. Once the maximum number of log files is reached, the server will begin recycling error log files.


If the number of error log files is too small then error log information may be lost making incident response and application debugging more difficult.

Applies To

  • Databases


This rule is applied when the following tags are present:

Tag With Value
secureclouddb/provider aws
secureclouddb/service rds
secureclouddb/engine sqlserver

Default Rule

const { getServerSetting } = module
 * @param {Object} databaseSettings - database settings object
 * @returns {boolean} true if maximum number log files is greater or equals to 12
function validate(databaseSettings) {
    const success = +getServerSetting(databaseSettings, 'numerrorlogs') >= 12

    return {