Alwayson Availbility group extended to Azure?..

  • Hello,

    Can databases on-Premise  Alwayson Availability group of SQL server 2017 failover to Microsoft Azure SQL database (PaaS)?

    Or it has to be IaaS?

    We don't have Azure VMs (IaaS) but only license for Azure SQL databases (PaaS).

    And How about Basic Availlbity group on Standard Edtion?



  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • There are two Azure SQL PaaS offerings: Azure SQL Database and Azure SQL MI (Managed Instance).

    Azure SQL Database is a single database; whereas Azure SQL MI is closer to a normal on-prem Instance (although not exactly the same).

    Both come with their own AlwaysOn AG (automatically created and managed for you). This is the foundation of Azure's high availability architecture in Azure SQL Database and SQL Managed Instance. I don't think it works, from an architecture point-of-view, for an on-prem AG to have a replica in Azure, which is itself part of another AG. Never mind the requirements for a WSFC.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply