Aqua CSPM

Audit Retention Policy

Quick Info

Plugin TitleAudit Retention Policy
CloudAZURE
CategorySQL Server
DescriptionEnsures that SQL Server Auditing retention policy is set to greater than 90 days
More InfoEnabling SQL Server Auditing ensures that all activities are being logged properly, including potentially-malicious activity. Having a long retention policy ensures that all logs are kept for auditing and legal purposes.
AZURE Linkhttps://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing
Recommended ActionEnsure that the storage account retention policy for each SQL server is set to greater than 90 days.

Detailed Remediation Steps