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

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

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

Rationale:

Audit Logs can be used to check for anomalies and give insight into suspected breaches or misuse of information and access.

Solution

From Azure Console

Go to SQL servers

For each server instance

Click on Auditing

Select Storage Details

Set Retention (days) setting greater than 90 days

Select OK

Select Save

Using Azure PowerShell
For each Server, set retention policy for more than or equal to 90 days

set-AzureRmSqlServerAuditing -ResourceGroupName <resource group name> -ServerName <server name> -RetentionInDays <Number of Days to retain the audit logs, should be 90days minimum>

Default Value:

By default, SQL Server audit storage is disabled.

See Also

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