Edit

Share via

Back up a SQL Server from the VM blade

  • Article

This article explains how to back up SQL Server running in Azure VMs with the Azure Backup service. You can back up SQL Server VMs using two methods:

  • Single SQL Server Azure VM: The instructions in this article describe how to back up a SQL Server VM directly from the VM view.
  • Multiple SQL Server Azure VMs: You can set up a Recovery Services vault and configure backup for multiple VMs. Follow the instructions in this article for that scenario.

Prerequisites

Before you start the SQL Server backup operation, see the backup prerequisites.

Before you start

Note

See the SQL backup support matrix to know more about the supported configurations and scenarios.

Configure backup on the SQL Server

You can enable backup on your SQL Server VM from the Backup blade in the VM. This method does two things:

  • Registers the SQL VM with the Azure Backup service to give it access.
  • Autoprotects all the SQL Server instances running inside the VM. This means that the backup policy is applied to all the existing databases, as well as the databases that will be added to these instances in the future.

  1. Select the banner on the top of the page to open the SQL Server backup view.

    Screenshot shows the SQL Server backup view.

    Note

    Don't see the banner? The banner is only displayed for those SQL Server VMs that are created using Azure Marketplace images. It's additionally displayed for the VMs that are protected with Azure VM Backup. For other images, you can configure backup as explained here.

  2. Enter the Recovery Services vault name. A vault is a logical entity to store and manage all your backups. If you create a new vault:

    • It will be created in the same subscription and region as the SQL Server VM that you're protecting.
    • It will be created with the geo-redundant storage (GRS) setting for all the backups. If you wish to change the redundancy type, you should do so before protecting the VM. For more information, see this article.

  3. Choose a Backup Policy. You can choose from the default policy, or any other existing policies that you created in the vault. If you want to create a new policy, you can refer to this article for a step-by-step guide.

    Screenshot shows how to choose a backup policy.

  4. Select Enable Backup. The operation may take a few minutes to complete.

    Screenshot shows how to select enable backup.

  5. Once the operation is completed, you'll see the vault name in the banner.

    Screenshot shows the Vault name in banner.

  6. Select the banner to go the vault view, where you can see all the registered VMs and their protection status.

    Screenshot shows the Vault view with registered VMs.

  7. For non-marketplace images, the registration may be successful, but configure backup may not be triggered until the Azure Backup extension is given permission on the SQL Server. In such cases, the Backup Readiness column reads Not Ready. You need to assign the appropriate permissions manually for non-marketplace images so configure backup can get triggered.

    Screenshot shows that the backup readiness isn't ready.

  8. For further operations or monitoring that you need to do on the backed-up SQL Server VM, go to the corresponding Recovery Services vault. Go to Backup Items to see all the databases backed up in this vault, and trigger operations such as on-demand backup and restore. Similarly, go to Backup Jobs to monitor jobs corresponding to operations such as configure protection, backup, and restore.

    Screenshot shows how to view backed-up databases in Backup Items.

Note

The backup isn't automatically configured on any of the new SQL Server instances that may be added later to the protected VM. To configure backup on the newly added instances, you need to go the vault that the VM is registered to and follow the steps listed here.

Next step

Learn how to: