Skip to content

Latest commit

 

History

History
18 lines (13 loc) · 887 Bytes

audit-retention-policy.md

File metadata and controls

18 lines (13 loc) · 887 Bytes

CloudSploit

AZURE / SQL Servers / Audit Retention Policy

Quick Info

Plugin Title Audit Retention Policy
Cloud AZURE
Category SQL Servers
Description Ensures that SQL Server Auditing retention policy is set to greater than 90 days
More Info Enabling 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 Link https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing
Recommended Action Ensure that the storage account retention policy for each SQL server is set to greater than 90 days.

Detailed Remediation Steps