Distributed Availability Group with Manual Seeding
11
votes
3
answers
5364
views
I am looking for a step by step walk through of how to setup a distributed availability group with manual seeding. I can get the automatic seeding working but when I try to manually seed I cannot get the secondary database into the AG on the forwarder.
If I add the distributed AG to the secondary before I try to add the database to the regular AG I get the following message:
Msg 41190, Level 16, State 7, Line 22
Availability group 'MYDB' failed to process add-database command. The local availability replica is not in a state that could process the command. Verify that the availability group is online and that the local availability replica is the primary replica, then retry the command.
If I try to add the DB first without joining the Distributed AG on the secondary, I get the following message because it thinks it should be a primary:
Msg 927, Level 14, State 2, Line 22
Database 'MYDB' cannot be opened. It is in the middle of a restore.
I have none of these problems with automatic seeding. Everything just magically works. All of the examples I find online use automatic seeding.
thanks in advance
Asked by Alf47
(981 rep)
Jun 21, 2018, 08:53 PM
Last activity: Jan 29, 2024, 10:39 AM
Last activity: Jan 29, 2024, 10:39 AM