Share via

SQL high availability Cluster ( One Node Onprema and Other on Azure)

Ravi_Azure 21 Reputation points
2021-12-23T10:11:27.773+00:00

Hi Team, we are working on High availability solution for ERP application. Backend Database in MS-SQL 2016 STD edition.

customer running Primary site on-prem and willing to run DR site from Azure . Web /Application /Database server will be DR site as Proposed solution. Current DR is on-Prem on secondary Datacenter .Same will be moved to Azure.

could you please suggest if any one work on such solution .

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

Answer accepted by question author

AmeliaGu-MSFT 14,016 Reputation points Microsoft External Staff
2021-12-24T02:48:57.42+00:00

Hi RaviAzure-9097,

Welcome to Microsoft Q&A.
Please refer to the following tutorials and docs:
Extend AlwaysOn SQL cluster in Azure – Step by step
Extend on-premises AlwaysOn Availability Groups to Azure
Hybrid IT: Disaster recovery solutions

Hope these can help you.

Best Regards,
Amelia

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ravi_Azure 21 Reputation points
    2021-12-27T06:18:14.337+00:00

    Thanks for your response. Will it support Zero RTO use case.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.