Creating SQL Backup Policies

Use the New Azure SQL Policy wizard to create a backup policy to protect SQL databases.

Important

Consider the following:

  • If public access is disabled on the SQL Server, the backup policy will attempt to create a private endpoint connection during the first run, which will initially fail. You must approve this connection request in the Azure portal for future policy runs to succeed; otherwise, the policy will continue to fail.
  • If public access is enabled, the backup policy will use the public endpoint, which requires port 3342 to be open for inbound connections, regardless of whether a private endpoint is also configured.
  1. Launch the New Azure SQL Policy wizard.
  2. Specify the policy details.
  3. Specify the policy source.
  4. Specify the policy protection settings.
  5. Specify database processing settings.
  6. Complete the backup policy configuration.