Setting up AlwaysOn Availability group on SQL Server on Azure Vm

Question

Hi,

I have installed SQL Server 2019 Developer edition on an Azure VM. While exploring, came across High Availability blade under SQL Virtual Machine - it was mentioned that I need to upgrade SQL Server edition to Standard or Enterprise edition before setting on HA.

I RDP to SQL Azure VM and enabled the Alwayson Feature on the SQL instance - Not sure if I would be able to set up AG with two Azure VMs with SQL Server Developer editions. Also it seems on premise SQL Server allows setting up AG on Developer edition. Just want to do it for learning purpose and not for Prod pupose.

I understand from Azure portal, we can not set up AG using Developer edition - but can it be setup manually ? Also is it allowed my Microsoft ?

Appreciate your insightful response. Thank you.

Answer 1

Hi @anil kumar
In SQL developer edition you can setup Always-On AG.
SQL Server 2019 developer is a full-featured free edition, licensed for use as a development and test database in a non-production environment.

Refer - step-by step guide for Always-On AG.

If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.