Solved

Merge Replication - Help needed

Posted on 2011-03-15
9
273 Views
Last Modified: 2013-11-05
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.
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
  • 5
  • 4
9 Comments
 
LVL 4

Author Comment

by:rocky_lotus_newbie
ID: 35141838
And we have immediate updating set up for the merge replication
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 35147587
Quote: "cluster, the primary server failed over to the secondary"

When the cluster fail over, the recieving node starts by running through the logfiles, committed actions will be committed, actions not committed will be rolledback, using rollback information in the log. So all databases (noregards to merge replication) will be in a cosistent state before they are initialized and accessable.

After that the merge replication does it's stuff.

So the answer id NO, there will not be any changes to the subscriber database thats not in the publisher database.

What can happen is a transaction in transition will be aborted before commit, and is rolled back. The immediate updating set will update WHEN the transaction is committed in the log file. This is NOT the same thing as written into the database. But since the recieving node reads through the logfile, this transaction will be committed and written into the database and thereby subscriber and publisher databases are in a synced state.

Regards Marten
0
 
LVL 4

Author Comment

by:rocky_lotus_newbie
ID: 35148830
Thanks for the reply Marten. The publisher and subscriber are indeed in sync.
Can you please let me know as to how I can find the specific records that might have been inserted or updated or deleted on the subscriber by the application after and during the failover? Please let me know if you need any additional info.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
LVL 20

Expert Comment

by:Marten Rune
ID: 35148910
These are also in sync. There is no problems with the databases due to a cluster failover. It's designed to be robust. There are no differenses in finding inserted, delted or updated records. If this is a requisit of the database it can be solved by triggers on the tables. But this is a totally different topic. Do you need references for creating alog/history table using triggers???
0
 
LVL 4

Author Comment

by:rocky_lotus_newbie
ID: 35149187
We didn't have any issues from the database standpoint due to the failover. But the Business requested for the data changes made at the subscriber from the application for validating it.
The failover happened between 10 AM and 11 AM EST yesterday, So can you please let me know as to how I can provide those specific data records  to the business?
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 35149992
You need to save all log files created beween 10AM and 11AM. Then you need some application to analyze these.
Backupfiles with logbackup works as I understand it.

lumigent log explorer should work, I only read up quick just now. Other suggestions here:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21514026.html

//Marten
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 35150071
The log explorer seems replaced with Audit DB
http://www.lumigent.com/company/news/lumigent-technologies-releases-audit-db%C2%AE-65

Havent tried but I think I will.

//Marten
0
 
LVL 4

Accepted Solution

by:
rocky_lotus_newbie earned 0 total points
ID: 35330085
Resolved by our senior DBA, not sure what he's done
0
 
LVL 4

Author Closing Comment

by:rocky_lotus_newbie
ID: 35510871
Not sure what's the answer to this question
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

634 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