Dear Expert
Currently I have one problem to my replication
In my senario I have 3 server in different branches and each hv one database that replicate each others.
All of the db use same ACL and all server added as Manager to all Databases.and all server also use same roles. the document inside has reader fields that set by the roles
ACL example
server1 ,Manager , Roles → [adminsvr1],[adminsvr2],[adminsrv3].
server2,Manager , Roles → [adminsvr1],[adminsvr2],[adminsrv3]
server3,Manager , Roles → [adminsvr1],[adminsvr2],[adminsrv3].
And server 1 is administration server for all db
currently replication will replicate successfully without any issue. But the problem always happen once I sign the db with active server id(Server1). All data in Server2 and Server3 will gone and deleted.
And currently this problem only can solve after I manually repl back to both of server ( from server1 to all server).
Any advise, thanks