November 15, 2023 at 4:12 pm
Hey Folks... need some guidance here.
Here's my current set up. Servers: S1, S3, S3, D1, P1.
3 servers in AOAG (S1, S2, S3). S1 is the primary with S2 and S3 as readonly (synchronous).
D1 is standalone setup as the Distributor. S1,S2,S3, and D1 are in DOMAIN1.
P1, is standalone with a database DB1. P1 is also in a different domain DOMAIN2
I am currently publishing DB1 from P1 to the AG using the AGListener. It works fine in a failover and is able to continue on.
I want to now publish DB1 from AG to another subscriber DB2. This can be on another server in DOMAIN2 but I currently have it on P1 as DB2 for this test. The replication is working but does NOT automatically switch to the new primary in a failover.
I'd like some help trying to figure this out.
TIA.
November 16, 2023 at 5:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply