SQL Server Configuration Settings option lost after ASR failover

Jeremy Pope 21 Reputation points
2020-10-29T14:04:41.887+00:00

I'm looking to consolidate my Azure Resources into a single region but having difficulties with VMs that have been built as SQL Virtual Machines. Azure Resource Mover won't touch them and ASR is apparently the recommended approach. Failover seems to work just fine, but in the target Resource Group, the SQL Virtual Machine resource does not get replicated and the SQL Server Configuration Settings option no longer appears.

Not sure if this causes an immediate functional issue, but it means I've lost the ability to change any aspect of the SQL Server configuration, Patching, Backups etc.

Anyone seen this before, or got any ideas?

Thank you.

Azure Site Recovery
Azure Site Recovery
An Azure native disaster recovery service. Previously known as Microsoft Azure Hyper-V Recovery Manager.
673 questions
Accepted answer
  1. SadiqhAhmed-MSFT 40,446 Reputation points Microsoft Employee
    2020-11-04T18:45:24.717+00:00

    @Jeremy Pope In the past we have come across a similar case and it was discovered that this SQL VM Resource relies on the SQL IAAS Extension being installed.

    As you may know, the failover operation doesn’t failover the VM Extensions, so you will need to reinstall that after failover.
    https://video2.skills-academy.com/en-us/azure/site-recovery/azure-to-azure-support-matrix

    37504-image.png

    After reinstalling the extension you may see this getting recreated at that time.

    ----------------------------------------------------------------------------------------------------------------------

    If the response helped, do "Accept Answer" and up-vote it

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest