Solved

how to validate sql server 2008 merge replication

Posted on 2011-03-15
1
457 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 39

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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to search for strings inside db views 4 24
SQL Error - Query 6 24
Show Results for Latest DateTime in a View 27 24
VB.NET 2008 - SQL Timeout 9 23
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

806 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