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 ?
Whats best way to replicate database (sql managed instance or Azure VM) from azure to on prem for a Disaster Recovery solution ?
@Arun-6084 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.
@Arun-6084 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.
thanks Kalyan. that helps. However I need specific solution using managed instance and sql VMs for disaster recovery?
For SQL VMs, would it be possible to have availability groups or log shipping be a disaster recovery solution (secondary site as on prem)?
10 people are following this question.
