Audit data for Azure SQL Server should be retained for greater than 90 days

문서 > Datadog 보안 > OOTB Rules > Audit data for Azure SQL Server should be retained for greater than 90 days

이 페이지는 아직 한국어로 제공되지 않으며 번역 작업 중입니다. 번역에 관한 질문이나 의견이 있으시면 언제든지 저희에게 연락해 주십시오.

Description

To ensure effective monitoring and detection of anomalies or breaches, it is recommended to configure SQL Server Audit Retention to be greater than 90 days. By doing so, audit logs are retained for a prolonged period, allowing for thorough investigation and analysis in cases of suspected misuse or security incidents. It is important to note that the default value for SQL Server audit storage is disabled, meaning that no logs are retained unless explicitly enabled and configured with a retention period.

Remediation

From the console

Go to SQL servers
For each server instance, click on Auditing
If storage is selected, expand Advanced properties
Set the Retention (days) setting greater than 90 days or 0 for unlimited retention
Select Save