Other Articles

SQL Databases – Enable Backup

Secure Configuration Checks > Azure

This check ensures that backups are configured for Azure SQL Databases. Azure takes automated backups of every database, and this check confirms that a backup retention period is set so data can be restored after accidental deletion, corruption or an outage.

Check Details

  • Resource: SQL Database
  • Check: Enable SQL Databases Backup
  • Risk: If backups are not configured with an adequate retention period, data cannot be restored to an earlier point in time, increasing the risk of permanent data loss.

Remediation via Azure Portal

  1. Log in to the Azure Portal. Azure Portal dashboard
  2. Navigate to SQL servers and select the affected SQL server. SQL servers list
  3. In the left menu, click on Backups under Data management. Backups in the SQL server menu
  4. Open the Retention policies tab, select the affected database and click Configure policies. Retention policies tab with the database selected
  5. Under Point-in-time restore (PITR), set the retention period in days (for example, 7 to 35 days). Optionally, configure long-term retention (weekly, monthly or yearly) if you need to keep backups for longer. Configure policies pane with retention days set
  6. Click Apply to save the changes.

Remediation via Azure CLI

  1. Open Azure Cloud Shell from the Azure Portal or use a local terminal with Azure CLI installed. Azure Cloud Shell
  2. Run the following command to set the point-in-time restore retention period:
    az sql db str-policy set \
    --resource-group <resource-group-name> \
    --server <sql-server-name> \
    --name <database-name> \
    --retention-days <retention-days>
    

    Replace <resource-group-name>, <sql-server-name>, <database-name> and <retention-days> with your actual values.

Updated on 03 November, 2026