Whats best way to replicate database (sql managed instance or Azure VM) from azure to on prem for a Disaster Recovery solution ?

Question

We are planning to have two primary instances on azure and have the third instance replicated on prem for DR solution.
Which model and technology would be best option to opt for ?

Answer 1

@Arun Azure SQL MI can be configured as a publisher with your on-premises database as a subscriber.
Please check this tutorial for more details.
You will have all the benefits of a managed database on Azure while still being able to replicate to your on-premises database.

If you need transactional replication, please ensure that you have a low latency connection over express route between your on-premises network and Azure so that you don't face any issues.

If you want to use SQL Server on Azure VM's, configuring log shipping is no different from doing it between 2 VM's on premises.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

Answer 2

@Arun Welcome to Microsoft Q&A forums and thank you for your interest in Azure services.

If Disaster recovery is your primary concern, you can set up Active geo replication across globally available datacenters and automatically failover in case of an outage.
However, if you still want to replicate the database to on-premises, you can use Azure SQL Database.
You can then set up SQL Data Sync to replicate data to your on-premises databases. More details are here

Please let us know if you have any further questions.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.