question

rehaan avatar image
rehaan asked

Distributed Availbility Group

hi friends, i want to migrate from sql2012 to sql2016 using distributed AG and then remove sql 2012. Does anyone has any experience, documents or video links. I have seen many videos to create distributed AG, but i don't see any video on how to remove one cluster from distributed AG
sql2016agdistributed-transaction
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
Look at this document from Microsoft - it is aimed at a cross cluster migration for OS upgrades, but there may be ideas in it that will help you plan a cross-cluster SQL upgrade : http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/AlwaysOn%20AG%20OS%20Upgrade.docx Also https://blog.dbi-services.com/sql-server-2016-distributed-availability-groups-and-cross-cluster-migration/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.