Skip to content

Increase Maximum Number Of Error Log Files

Description

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.

Rationale

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

Tags

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 {
        success,
    }
}

validate(databaseSettings)