Solved

how to validate sql server 2008 merge replication

Posted on 2011-03-15
1
464 Views
Last Modified: 2012-08-13
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
Comment
Question by:rocky_lotus_newbie
1 Comment
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 35141968
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question