Under EM's Replication Monitor/Publishers/pub1/publisher1 there is a "Validate Subscriptions" option on the right-click menu. Since I see unexplained Replication Validation activity I think that the "Validate Subscriptions" option is turned on. But there is no "turn-off" button or way to say "stop." Does anyone know how this "feature" works?
Thanks
I would suggest that you script the publication out and look at it in Query Analyser.
It may not be obvious what the parameter is as sometimes the description we see in the GUI is far different from what the parameter might mean. You can always look up the parameters in BOL to make sure you understand them.
We have previously used this technique to set some of the less obvious options.
|||Thanks for your response. I did what you suggested and I see nothing suggestive of validation. It must be hidden elsewhere!
|||Does your agent job have a parameter -Validate 1 or -Validate 3?
Also check if any of your agent profiles have this parameter set.
No comments:
Post a Comment