Merge Replication - Help needed
Posted on 2011-03-15
We have merge replication supported on a cluster, the primary server failed over to the secondary. After that, there might be some changes made to the data by the application during and after the failover happened, so all the changes could have been done on the subscriber database (not sure if there are any changes). Now the business would like to know if there were any changes on the subscriber database data, if it happened, they want to know what are the changes and whether those changes got replicated to the publisher database. Can any one please help me as to how I can find that? BTW, we have SQL 2008 R2 Enterprise on Windows 2008 R2 Enterprise. Please let me know if you need any additional information. Thanks.