Twice I had to ask how to do this – so it is probably time for me to write it down.
Setting the scene – this was a virtual SQL Server hosted on Azure where I had already configured a backup policy within the Portal, and then wanted to add another database to that policy.
Clicking around in the Backup center and Backup policy screens did not help. The trick was to go through the motions of taking a backup.
- Within the Backup center click “+ Backup”
2. On the next screen make sure the Datasource type is “SQL in Azure VM” before selecting the right vault.
3. Choose “Configure Backup” …
4. Click “Add” …
5. Then – you can choose the Instance (or AlwaysOn AG), database, then Enable Backup. Simples 🙂