Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 490
  • Last Modified:

how to validate sql server 2008 merge replication

Hi Experts,

We had a SQL Server Cluster Failover for Publisher in a merge replication. I would check the logreader, dist and merge agents to see if they are succesful.

Can you please let me know if there are any validation methods/scripts available to validate the data is in Sync.

Thanks,
0
rocky_lotus_newbie
Asked:
rocky_lotus_newbie
1 Solution
 
lcohanDatabase AnalystCommented:
The link below has all the system SP_... that you can use to check your replication status and if I understand corectly what the easiest way to check it is if you look on anyone of the databases in merge scenario the latest data entry/change into any user table part of the merge replication must be found (not instantaneoulsy but quick anough) on any other database table part of the merge scenario.


http://msdn.microsoft.com/en-us/library/ms147874.aspx

in particular you could monitor merge changes waiting to be uploaded or downloaded by running:

1.At the Publisher on the publication database, execute sp_showpendingchanges
2.At a Subscriber on the subscription database, execute sp_showpendingchanges
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now