Solved

how to validate sql server 2008 merge replication

Posted on 2011-03-15
1
474 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

752 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