In our AlwayOn environment I have two SQL servers 2014 Ent.edition (SERVER A, and SERVER B). I setup a transaction replication for [database A ], pointing to listener which shouldn't cause any issue if a failover happened. Tested, worked just fine after a failover, but when I shut off one of the servers in AOAG ,in test environment, replication stops working. There is no error on the replication monitor. For testing purpose,I have inserted few records on the database it works fine on AOAG, but on the Subscriber the data modification is not replicated until I bring up the other server. Once the server is up, then the replication start to work. I'm pretty sure, I might be missing something, this can't be this way by design.
Any Idea/recommendation ?
Here is what I have for Replication on AOAG.
- Distribution Server A ( contains Distribution database ) - SQLSERVER
- This on a remote server.
- two subscribers - Sv1 and sv2 - SQLSERVER 2008R2 STANDARD
- Pbulishers ( SERVER A and B - from AOAG ) - SQLSERVER 2014