Using Azure Recovery Vault to backup SQL Server within your Virtual Machines
In this blog post I’ll show you how to go about baking up SQL Server within your VM’s on Azure. I’m going to assume you have created an Azure Recovery Vault already.
Step 1 – Log into Azure and go into your Recovery Vault.
Step 2 – Click Backup.
Step 3 – Choose SQL Server in Azure VM (Preview).
Step 4 – Choose Start Discovery and that goes off to discover your VM’s which have SQL Server on them.
Step 5 – Select the Virtual Machine name(s) from the list and then hit the Discover DB’s button.
Step 6 – Select Configure Backup.
Step 7 – Select from the list the instance(s) and then select the DB’s you wish backed up, you can also change the AutoProtect to ON from the drop down and this will always backup each new database added going forward.
Step 8 – Select Ok.
Step 9 – Choose your Backup Policy Options.
And that should be that, you now have your SQL Server’s within your VM’s on Azure backed up using a Policy which you can configure to suit your needs and change ant any time you wish.