There are many ways we can backup up the SQL Databases in Azure services, even if these are running on SQL Azure or a SQL Server Virtual Machine. In this post, we will talk about Azure Backup for SQL Server Virtual Machines, a way that previously became General Available (GA).
At the image below we can see what exactly we need to deploy the Azure Backup service for a SQL Server VM.
- An active Azure Subscription
- An Azure Resource Group under the Azure Subscription
- Two Azure services, a SQL Server Azure VM(s) and an Azure Recovery Service Vault
How it works
The whole procedure for backup and restore databases from a SQL Server Azure VM to an Azure Recovery Vault is fully automated and it only needs few clicks to configure the Recovery Service Vault (at the Create Recovery Vault section, we are going to see how this can be done).
The Procedure Step by Step
When we select the SQL Server Azure VM that we want to enable Backup procedure the Azure Backup Service install a workload backup extension. This extension consists of a plugin (AzureWLBackupPluginSvc) and a coordinator (AzureWLBackupCoordinatorSvc), the first is responsible for the data flow and the second for triggering workflows for several operations.
Find more details about how Azure Backup Service works in the Microsoft official document, Backup Process .