Azure SQL Server Availability Group on VM downsize.

Question

Hi,

I want to downgrade a VM hosting a replica member of an SQL Availability Group on Azure VMs.

I plan to donwgrade the secondary replica using Azure Portal / VM / Setings / Size. I have checked the target size and it is available.

Has anyone faced something strange with that? Is there a conflict with Failover Cluster/Availability Group? Is there any other proposed way to do this?

Thank you in advance,

Marios

Answer 1

@Marios Pavlidis

Downgrading a VM hosting a replica member of an SQL Availability Group on Azure VMs is possible. You can use Azure Portal / VM / Settings / Size to change the size of the VM. However, before you proceed, you should consider the following:

• Make sure that the target size is available in the region where the VM is hosted
• Verify that the target size meets the minimum requirements for the replica member of the SQL Availability Group.
• Check if there are any capacity reservations in place for the target size. If there are, make sure that you have the required capacity reservation before you proceed with the downgrade.
• Verify that the target size is compatible with the operating system and applications running on the VM.

Regarding your question about conflicts with Failover Cluster/Availability Group, changing the size of a VM should not affect the Failover Cluster/Availability Group. However, it is always recommended to perform this operation during a maintenance window to avoid any potential impact on the availability of the application.

If you face any issues during the downgrade process, you can check the Azure Portal notifications and the VM's activity log for more information. If you need further assistance, please let me know.

I hope this helps! Let me know if you have any other questions.

---

If you still have questions, please let us know in the "comments" and we would be happy to help you. Comment is the fastest way of notifying the experts.

If the answer has been helpful, we appreciate hearing from you and would love to help others who may have the same question. Accepting answers helps increase visibility of this question for other members of the Microsoft Q&A community.

Thank you for helping to improve Microsoft Q&A!