How to manaully Sync the subcriber data in Disaster

Posted on 2012-04-05
Last Modified: 2012-06-11
Dear Experts

there is a problem in the replciation and i want to update my publisher from the subscriber backup

can you please suggest if there is any way to do the same manually.

Best regards
Question by:Solutions4Problems
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
  • 3
  • 3
  • 2
  • +1
LVL 15

Expert Comment

ID: 37809787
First, run tablediff utility to find the difference in data and copy this difference to a table (this is for backup purpose if anything went wrong). The option is to reinitialize your subscription, here you have the options Upload unsynchronized changes from the subscribers before reinitialization. Once the changes are uploaded the merge agent will overwrite the subscriber data with the punlisher, This applies only for merge replication.
LVL 43

Expert Comment

by:Eugene Z
ID: 37810195
..script publisher\subscriber (later you need it to recreate publication)
1. have a good backup of publisher and subscriber DBs
2. drop subscription and publication
3. update publisher from the subscriber backup (please clarify -... if it is table copy, db restore , etc)-- if db restore you mayneed to do some extra steps  -
4.make sure your  "to be again" publisher db \tables look as you expect
5. recreate publication\subscription(s)

BTW:  what repilcation are you using ? is it snapshot publication?

Author Comment

ID: 37810339
I am using merge replciation and the steps you have suggested is not possible as the data is updated at both the ends

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

LVL 15

Accepted Solution

Anuj earned 167 total points
ID: 37810370
The option i see is to reinitialize the subscription with " Upload unsynchronized changes from the subscribers before reinitialization".

Assisted Solution

SJCFL-Admin earned 166 total points
ID: 37811111
I have had many cases where the merge replication would not let me upload changes from the subscriber.  In that case, you have to let it re-initialize the subscription.  but if you could restore the backup to another instance and do the tablediffs as described by anujnb, you could develop scripts to apply the changes to the publisher and that would cause them to replcate again down to the subscribers.  (Or you could manually write T-SQL using EXCEPT logic to effect the same types of compares and feed the results to INSERT or UPDATE statements to automatically apply the changes. But whatever you do, you would be responsible for understanding the data and preventing the introduction of errors into the process.)
LVL 43

Assisted Solution

by:Eugene Z
Eugene Z earned 167 total points
ID: 37814410
try conflict resolver
Advanced Merge Replication Conflict Detection and Resolution

Author Closing Comment

ID: 38061551

Expert Comment

ID: 38062098
One thing I have found over the years is that what users ask for isn't usually a good thing to give them if I have not checked out the full scope of the effect.  One of the reasons i like the table diffs is that it will give you a heads up as to whether any other changes are going to be made other than what you are expecting.  I've aften been requested to do a full restore only to discover that the request was made totally ignoring another oeprational area that would have been adversely impacted if I have done a full restore.

I am also not sure how conflict resolver plays in here.  That only identifies conflicts Sql Server cannot resolve if two changes are made to the same entity at the same time and Sql Server could not determine who should win. (Unless I am missing a capability that I am unaware of and would be extremely interested in exploring further...)
LVL 43

Expert Comment

by:Eugene Z
ID: 38064304
please read EE help about C grade -- it is like to say somethin bad to people who try to help you
So not nice  :(

if you got it - try to change your grade

Expert Comment

ID: 38069728
Perhaps it is our obsession about metrics that needs to change :-)   Sometimes we will give a user exactly what they want and sometimes we won't.  The is that old saying that if you are not making mistakes, you aren't doing anything.  Or at least, you are not trying to expand your horizons.

So what is wrong if we do not always get an A ?  Why should we be evaluated only on a grade rather than the content of what we said or the fact that we tried to help.

But then I stopped participating in peer code reviews whan management decided they needed to be 'measured' for 'flaws'.  That immediately ended the free flow discussion of what might have been done or techniques that could be sued the next time. Instead, it became a tool for scoring points against those you disliked and adding points for those you did.  All by whether or not you listed the 'flaws' you found...  But management , in particular, like easy answers they can poinit to for the illusion of quality control and objectivity.  I have not met an 'objective' measurement yet that could not be corrupted once people knew it was being measured...

Sorry for the long reply.  I wish people could acccept that grades are relative to peoples expectations and sometimes their expectations can't be achieved as they want...

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
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.

632 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