Skip to Content
0
Former Member
Aug 05, 2016 at 12:12 AM

repserver 2 way query

45 Views

I have setup master MSA replication from server msa01 to msa02.

This works fine. When I add login to msa01 or change password it gets replicated to msa02. No threads down and looks good.

Then I added MSA replication from msa02 to msa01. create db repdf and subscription. (2 way MSA replication)

Now when I add login syb_test on msa02, it replicates to msa01 and I see the syb_test created on msa01, but the rep agent picked up this transaction and tried to create the login again on msa02 (where it already exists) and thread goes down. It kinda goes in ifinite loop.

The master rep agent on both mas01 and mas02 has 'send maint xacts to replicate' false and 'semd warm standby xact' is true.

Also during setup I had run following reading manuals:

alter connection to msa01.master set dsi_replication to 'on'

alter connection to msa02.master set dsi_replication to 'on'

What other setting is needed to avoid rep agent pick up and replicate the maint user transactions ?