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

10 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
  8. HuongkvbAugust 2, 2021 at 7:27 PM

    Liên hệ Aivivu, đặt vé máy bay tham khảo

    vé máy bay đi Mỹ bao nhiêu tiền

    mua vé máy bay từ mỹ về việt nam

    bay từ nhật về việt nam

    vé máy bay khứ hồi từ đức về việt nam

    vé máy bay giá rẻ từ Canada về Việt Nam

    vé máy bay vietjet từ hàn quốc về việt nam

    khách sạn được cách ly tại hà nội

    Chi phi cho chuyen gia nuoc ngoai

    ReplyDelete
  9. Model PapersJune 20, 2022 at 6:59 AM

    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.

    ReplyDelete

Subscribe to: Post Comments (Atom)