question

Arun-6084 avatar image
0 Votes"
Arun-6084 asked Arun-6084 commented

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

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 ?

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KalyanChanumolu-MSFT avatar image
1 Vote"
KalyanChanumolu-MSFT answered Arun-6084 commented

@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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thank you...that helps ... but as we speak transactional replication is still as preview feature right ? Could you please confirm... if yes , may i know the impact of implementing this in prod ?

0 Votes 0 ·

any updates ?

0 Votes 0 ·
KalyanChanumolu-MSFT avatar image
1 Vote"
KalyanChanumolu-MSFT answered Arun-6084 commented

@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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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)?

0 Votes 0 ·