Compliancemanzill.com
CIS Microsoft Azure Foundations Benchmark v1.4.0

CIS Microsoft Azure Foundations Benchmark v1.4.0/Database Services/52 of 115

4.1.3Ensure that 'Auditing' Retention is 'greater than 90 days'

Control family: Database Services

Control description

SQL Server Audit Retention should be configured to be greater than 90 days.

How to implement

ResponsibilityCustomerYou configure and operate this in your own cloud accounts.

Audit records are only useful if they still exist when you need them, often months after an incident starts. Audit logs written to a storage account are kept for more than 90 days (or indefinitely, with a retention of 0).

Before you start

The same on every cloud, before the steps in the tabs.

  • Decide how long SQL audit logs are kept (more than 90 days, often a year), in line with your logging standard.

Evidence

  • The retention requirement in the logging standard

On Azure the tasks set the audit retention for each SQL server's storage destination, then keep it checked with the CIS standard.

Task 1Keep audit logs for more than 90 days

  1. Sign in to the Azure portal at portal.azure.com and open SQL servers, then the server.
  2. Select Security > Auditing.
  3. Under the storage destination, open Advanced properties.
  4. Set Retention (Days) to more than 90, or to 0 to keep logs without a limit.
  5. Select Save.
  6. Check it: the auditing page shows the new retention. If logs go only to Log Analytics, set the workspace retention instead.

Task 2Keep it checked with the CIS v1.4.0 standard in Defender for Cloud

  1. Open Microsoft Defender for Cloud > Regulatory compliance and select Manage compliance policies.
  2. Select the subscription, select Security policies, find CIS Microsoft Azure Foundations Benchmark v1.4.0 and toggle its status to On (once per subscription).
  3. Back on Regulatory compliance, open the CIS Microsoft Azure Foundations Benchmark v1.4.0 standard and expand recommendation 4.1.3.
  4. Open the assessment for SQL servers with auditing to storage account destination should be configured with 90 days retention or higher and fix the resources it lists as non-compliant.
  5. Check it: every resource under recommendation 4.1.3 shows as passing after the next evaluation.

Evidence

  • Auditing of each SQL server, showing retention above 90 days
  • The CIS v1.4.0 standard, with recommendation 4.1.3 passing

Console steps as of 5 November 2026. Not every step has been confirmed in a live console yet, and menus and labels can move between releases, so look for the nearest match if one has changed.