5.1 Ensure 'Maximum number of error log files' is set to greater than or equal to '12'

Information

SQL Server errorlog files must be protected from loss. The log files must be backed up before they are overwritten.

Solution

Adjust the number of logs to prevent data loss. The default value of 6 may be insufficient for a production environment.
1. Open SQL Server Management Studio.
2. Open Object Explorer and connect to the target instance.
3. Navigate to the Management tab in Object Explorer and expand. Right click on the SQL Server Logs file and select Configure
4. Check the Limit the number of error log files before they are recycled
5. Set the Maximum number of error log files to greater than or equal to 12

See Also

https://workbench.cisecurity.org/files/2364

Item Details

Category: AUDIT AND ACCOUNTABILITY

References: 800-53|AU-11, CSCv6|6.3, CSCv7|6.4

Plugin: Windows

Control ID: 0bcf8e1b8585b5d3aeb81d151ebef1f2d8727b355ee8b43ee9d3ce05f0f969f5