SQL Server software libraries must be periodically backed up.

From Microsoft SQL Server 2012 Database Instance Security Technical Implementation Guide

Associated with: CCI-000537

SV-53279r2_rule SQL Server software libraries must be periodically backed up.

Vulnerability discussion

SQL Server backups are a critical step in maintaining data assurance and availability.System-level information includes system-state information, operating system and application software, and licenses.Backups shall be consistent with organization-defined recovery time and recovery point objectives.SQL Server depends upon the availability and integrity of its software libraries. Without backups, compromise or loss of the software libraries can prevent a successful recovery of SQL Server operations.A mixture of full and incremental server-level backups by a third-party tool that backs up those software library directories would satisfy this requirement.

Check content

Review evidence of inclusion of SQL Server software libraries in current backup records. If the backup tool does not include SQL Server, this is a finding.

Fix text

Ensure inclusion of all SQL Server software libraries into the backup process.

Pro Tips

Lavender hyperlinks in small type off to the right (of CSS class id, if you view the page source) point to globally unique URIs for each document and item. Copy the link location and paste anywhere you need to talk unambiguously about these things.

You can obtain data about documents and items in other formats. Simply provide an HTTP header Accept: text/turtle or Accept: application/rdf+xml.