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

2 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

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)