Ensure Azure SQL audit logs are retained adequately
SQL audit logs should be retained for at least 90 days for compliance.
Security Impact
Short retention may not meet compliance requirements for investigations.
How to Remediate
Configure audit log retention in storage account or Log Analytics workspace.
Affected Resources
Compliance Frameworks
How TigerGate Helps
TigerGate continuously monitors your Azure environment to detect and alert on this misconfiguration. Here's what our platform does for this specific check:
- Continuous Scanning
Automatically scans all Azure SQL Database resources across your Azure subscriptions every hour
- Instant Alerts
Get notified via Slack, email, or webhooks when this misconfiguration is detected
- One-Click Remediation
Fix this issue directly from the TigerGate dashboard with our guided remediation
- Compliance Evidence
Automatically collect audit evidence for CIS Azure v1.5.0, SOC 2, PCI-DSS compliance
- Drift Detection
Get alerted if this configuration drifts back to an insecure state after remediation
Check Details
- Check ID
- azure-sql-9
- Service
- Azure SQL Database
- Category
- Logging
- Severity
- MEDIUM
- CIS Benchmark
- 4.1.6
Automate This Check
TigerGate automatically scans your Azure environment for this and 160+ other security checks.
Start Free Trial