compliance.tf
Azure Compliance ControlsAzure SQL Database

SQL servers auditing to storage accounts should have retention set to 90 days or more

For incident investigation purposes, set the data retention for your SQL Server' auditing to storage account destination to at least 90 days. Confirm that you are meeting the necessary retention rules for the regions in which you are operating.

What this control checks

SQL server auditing to a storage account has retentionDays of 90 or more (or 0).

Framework mappings

The clauses this control is mapped to in each framework.

NIS2 Directive (EU 2022/2555)

  • 3 Incident handling
  • 4 Business continuity and crisis management
  • 6 Security in network and information systems acquisition, development and maintenance
  • 12 Asset management

NIST SP 800-53 Rev 5

  • Audit Record Retention (AU-11)

NIST Cybersecurity Framework v2.0

  • RS.AN-06: Actions performed during an investigation are recorded, and the records' integrity and provenance are preserved.

FedRAMP Moderate Baseline Rev 4

  • AU-11: Audit Record Retention

NIST SP 800-171 Rev 2

  • 3.3.1: Create and retain system audit logs and records to the extent needed to enable the monitoring, analysis, investigation, and reporting of unlawful or unauthorized system activity
  • 3.3.2 Ensure that the actions of individual system users can be uniquely traced to those users, so they can be held accountable for their actions

BSI C5:2025

  • OPS-06.01B Policies and instructions for at least daily backup and restore of cloud service customer data, cloud service derived data and cloud service provider data according to the sensitivity of the data are documented, communicated and provided in accordance with SP-01 regarding the...
  • OPS-12.01B The requirements for the logging and monitoring of events and for the secure handling of cloud service derived data and cloud service provider data are implemented by technically supported procedures with regard to the following restrictions: - Access only for authorised users and...
  • OPS-14.02B Log data is deleted if it is no longer required for the purpose for which it was collected.

CIS Azure Benchmark v2.0.0

  • 4.1.6 Ensure that 'Auditing' Retention is 'greater than 90 days'

CIS Azure Benchmark v2.1.0

  • 4.1.6 Ensure that 'Auditing' Retention is 'greater than 90 days'

CIS Azure Benchmark v3.0.0

  • 5.1.6 Ensure that 'Auditing' Retention is 'greater than 90 days'

CMMC 2.0 Level 2

  • AU.L2-3.3.1 Create and retain system audit logs and records to the extent needed to enable the monitoring, analysis, investigation, and reporting of unlawful or unauthorized system activity
  • AU.L2-3.3.2 Ensure that the actions of individual system users can be uniquely traced to those users, so they can be held accountable for their actions

HIPAA Security Rule 2003

  • 164.308(a)(1)(ii)(D): Administrative Safeguards
  • 164.312(b) Audit controls

Tool mappings

Use these identifiers to cross-reference this control across tools, reports, and evidence.

  • Compliance.tf Control: sql_server_auditing_storage_account_destination_retention_90_days
  • Checkov Check: CKV_AZURE_24
  • Powerpipe Controls: azure_compliance.control.sql_server_auditing_retention_period_90, azure_compliance.control.sql_server_auditing_storage_account_destination_retention_90_days
  • Prowler Check: sqlserver_auditing_retention_90_days
  • Azure Policy Definition: 89099bee-89e0-4b26-a5f4-165451757743
  • KICS Queries: 59acb56b-2b10-4c2c-ba38-f2223c3f5cfc, 9c301481-e6ec-44f7-8a49-8ec63e2969ea
  • Trivy Check: AZU-0025

Last reviewed: 2026-10-15

View all Azure controls →

On this page

Ask AI about this

Help improve this page