November 10, 2020 at 2:05 pm
Is there a guideline or does anyone have any step by step process on removing Distributed Availability group between 2 servers properly? I am trying to beak it a part because the secondary server (forwarder) is old and ready to be decommissioned.
This is how servers are setup:
DAG between SQL1P (forwarder) and SQL2P (primary)
Another DAG between SQL2P (forwarder) and SQL3P (primary).
I need to remove the DAG between SQL1P (forwarder) and SQL2P (primary) . Any help is highly appreciated.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
November 11, 2020 at 2:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
November 16, 2020 at 12:57 am
Hopefully someone has a proper list for you but it would be something along the lines of:
Cancel automatic seeding for the distributed group (seeding mode = manual).
On SQL2P - ALTER DATABASE Databasename SET HADR OFF
That should leave the databases 'restoring' so they can be deleted.
DROP AVAILABILITY GROUP [DistributedAvGroup]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply