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


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?


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


  1. please provide the document which is mentioned in video.

  2. Would you please provide the scripts?

  3. Please provide the scripts who have run on SQL-T

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

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

  6. This Website will give Tripura Board 10th Question Paper 2023, Usually give an overview of the Exam Format, It also helps to Assess a Student’s Performance in Studies, We can say That it is Important to solve These Papers 2023, as it helps a Tripura Board 10th Student to Gain Practice and be more Confident to face the Exam. Tripura 10th important Questions 2023 All Subjects Published by Tripura Board of Secondary Education is a Board of School Education in the state of Tripura, India Only are very Reliable, Tripura Board 10th Student You can Download Pdf Format Official websites also, TBSE 10th Sample Question Paper 2023 are a Great Tool to evaluate their Performance and work on Their Strengths and weaknesses.