sql-2016-alwayson - SqlVmIaasExtension's automated backup is not available to HA's sql VMs.

[Kuma569]

I'm new to the MS SQL HA stuff so this might be a simple question. But after the deployment of the sql-2016-alwayson, I don't see SqlVmIaasExtension's automated backup settings on both primary and secondary sql VMs, which is available to the sql 2016 standalone deployment (from the marketplace).

Does anybody know the reason why? I'd like to set up automated database backup for the tenant databases.

Or, for HA, do we have to run the script like the one in the link below? https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-multiple-databases-to-azure-blob-storage-powershell?view=sql-server-ver15

Any advise?

[Kuma569]

FYI - I opened a support ticket to MS, and figured out that it's not supported :( Here is their comments;

"... automated back up capabilities is not available for Alawys ON (HA) configuration in AzureStack , hence it's by design... "

So for our solution, Simply I set up a backup script that I referred in my previous post, and running it using Ansible.