I have transaction replication configured on SQL 2K8 R2 machines. Replication streams are going from multiple publisher tp multiple subscribers(pull and push) all these are
using a single remote distributor. After couple of test efforts we came with desired values for agent profile parameters; and created some custom Replication Agent profiles (snapshot/Logreader/distribution) for each and every replication
Now, I am not able to change the replication Agent profile through replication monitor. After selecting the desired agent aginst check box in "Use for this Agent" column, its
going back to old Agent profiles.
It’s happening with only one or two replication steam in the remote distributor.
Can you please let me know whats wrong in it?
View Complete Post