Azure-SQLDatabases-DB-Restorable

Severity : Medium

Description: This control ensures that Azure backup recovery service have recovery points retention to successfully restore the SQL Database. Azure backup service provides automatic backup which creates recovery points for the VM. The retention of these recovery points are driven by the retention periods for the backup. The initial backup is full backup and subsequent backups are incremental backup. When the recovery points have the retention periods expires, they are merged to next recovery points. If a recovery point is deleted before the next one created , the recovery mechanism will be broken as previous data has already been deleted. Automated backups of SQL databases with recent restore points help ensure that database recovery operations can occur without significant data loss.

Remediation Steps:

Perform following to configure retention period for recovery point :

1. Login to Azure Portal using https://portal.azure.com.

2. Navigate to All services.

3. Filter for SQL databases, select the SQL database.

4. From the list of SQL databases , Select the reported database.

5. On Overview, Select Restore.

6. If no Point-in-time or long-term backup available, it requires backup configuration

7. On the data base, Select Backup policy.

8. Update the Retention Range for the back up policy to make sure that it beyond the backup period.

9. Select OK.

Important:

Reference:

• https://docs.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?tabs=single-database