How to setup Distributed Availability Group in SQL Server 2016 - SQL Server 2016 DBA Tutorial

Scenario:

You are working as SQL Server DBA and you are asked to setup Distributed Availability Group in SQL Server 2016, What steps would you follow?

Solution:

The video demo, will explain all the steps you need to take to configure Distributed Availability Group. Demo covers below items

  • What is Distributed Availability Group in SQL Server 2016?
  • What are pre-requisites of Distributed Availability Group in SQL Server 2016?
  • How to create availability groups on different clusters to use in Distributed AG?
  • How to create Availability Group with Automatic seeding
  • How to create Listener in Availability Group
  • How to setup Distributed Availability Group using two different listeners?
  • How to Join Secondary cluster in Distributed Availability Group?
  • How to check status of Distributed Availability Group
  • Troubleshooting Distributed Availability Group


Part 1



Part 2



Part 3

7 comments:

  1. AnandApril 8, 2019 at 9:56 PM

    please provide the document which is mentioned in video.
    Thanks

    ReplyDelete
  2. smtApril 14, 2019 at 7:33 AM

    Would you please provide the scripts?

    ReplyDelete
  3. BBBJuly 29, 2019 at 9:08 AM

    Please provide the scripts who have run on SQL-T

    ReplyDelete
  4. MHAugust 15, 2019 at 4:48 PM

    Please...

    ReplyDelete
  5. LuisNovember 21, 2019 at 9:53 PM

    Can you confirm if I can configure DAG with Sql-Server 2017 Standard?

    ReplyDelete
  6. VictoriaNovember 26, 2019 at 2:44 AM

    Nice step-by-step guide, thanks for videos .

    ReplyDelete
  7. Mahendra ShuklaAugust 2, 2020 at 4:13 AM

    great sir

    ReplyDelete

Subscribe to: Post Comments (Atom)