Ensure point-in-time-restore is enabled for Azure SQL Database

MEDIUM

Description

Azure SQL Database instances have point-in-time-restore disabled, this make data recovery challenging during an incident.

Remediation

Set 'restore_point_in_time' and 'create_mode' to organization specified values to enable point-in-time-restore for Azure SQL Database. Point-in-time-restore helps in backups and disaster recovery through regular and trigger based backups.

Policy Details

Rule Reference ID: AC_AZURE_0259
CSP: Azure
Remediation Available: Yes
Resource Category: Database
Resource Type: SQL Server

Frameworks