Solved

How to manaully Sync the subcriber data in Disaster

Posted on 2012-04-05
10
409 Views
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
Shailesh
0
Comment
Question by:Solutions4Problems
  • 3
  • 3
  • 2
  • +1
10 Comments
 
LVL 15

Expert Comment

by:Anuj
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.
0
 
LVL 42

Expert Comment

by:EugeneZ
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?
0
 

Author Comment

by:Solutions4Problems
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

regards
shailesh
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 15

Accepted Solution

by:
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".
0
 
LVL 6

Assisted Solution

by:SJCFL-Admin
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.)
0
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 167 total points
ID: 37814410
try conflict resolver
Advanced Merge Replication Conflict Detection and Resolution
http://msdn.microsoft.com/en-us/library/ms151257(v=sql.100).aspx
0
 

Author Closing Comment

by:Solutions4Problems
ID: 38061551
###
0
 
LVL 6

Expert Comment

by:SJCFL-Admin
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...)
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 38064304
Solutions4Problems:
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
0
 
LVL 6

Expert Comment

by:SJCFL-Admin
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...
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
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.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

831 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