Creating SQL Backup Policies


SQL backup policies can protect only Azure SQL databases running on SQL Servers and databases located on SQL Managed Instances. If you want to protect a database hosted by a SQL Server on Azure VM, create an Azure VM backup policy. Note that in this case, you will not be able to restore a single database without restoring the entire VM.

To create a backup policy, do the following:

  1. Launch the Add Azure SQL Policy wizard.
  2. Specify a backup policy name and description.
  3. Configure backup source settings.
  4. Configure processing options.
  5. Create a schedule for the backup policy.
  6. Specify automatic retry, health check and notification settings for the backup policy.
  7. Review the estimated cost of protecting the selected Azure SQL databases.
  8. Finish working with the wizard.