Share via

SQL SERVER Always on DR

Ahmed Maher Abdelsalam 21 Reputation points
2020-11-24T06:37:47.62+00:00

I have separated 2 datacenters with separated failover windows clusters S2D (DR, DC) under one domain, and I need to know how to create distribution group between both sites while all my servers which host my application (Microsoft Dynamics AX 2012) and database (SQL Server 2016 enterprise) is a virtual machines.

HOW TO GET ALWAYS ON DONE ON VIRTUAL ENVIRONMENT

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories


Answer accepted by question author

Shashank Singh 6,251 Reputation points
2020-11-24T09:06:50.737+00:00

To configure Distributed AG please follow below blog

setup-and-implement-sql-server-2016-always-on-distributed-availability-groups

The process to configure AG on physical and virtual machine is same.
Below is 2 part series for configuring AG

sql-server-alwayson-availability-groups--part-1-configuration

Was this answer helpful?


1 additional answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 14,016 Reputation points Microsoft External Staff
    2020-11-25T06:22:10.077+00:00

    Hi @Ahmed Maher Abdelsalam ,

    As others mentioned, configuring the windows failover cluster on the physical environment is similar to configuring it on the virtual environment. Here is a tutorial video which could help.
    And here is a tutorial for configuring Distributed availability group.

    Best Regards,
    Amelia


    If the answer is helpful, please click "Accept Answer" and upvote it.
    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.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments

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.