March 23, 2011 at 5:43 am
Hi can anyone help me on this!!!!
In Transaction and merge replication if the publisher and the subscriber are not in sync what will u do?
March 23, 2011 at 7:28 am
are you asking how to get them back in synch or what the overall health of the DB is?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 23, 2011 at 8:21 am
Also, why are they not in synch? Did something break? Was something stopped?
March 23, 2011 at 10:33 am
Hi Dan
I just want 2 know how to get them back in sync and what are the possible ways for that....
Hi Brandie
I dont know why they are not in sync? I was asked in an interview how will u resolve if they are not Sync?
Thanks for ur responce guys....
March 23, 2011 at 10:41 am
If this is something you are just trying to add to your knowledge base based on an interveiw question you would need to do some reading into replication methods. Brandies's question is probably the most important becuase why they are out of synch would largely dictate how you respond. but in SMS there is a snapshot and replication monitor in which you could a trigger a new snapshot if necessary and b trigger a synch from the subsriber. The latter would bring the subsriber back into synch assuming nothing overly disasterous has occurred. For example after an upgrade to SQL it may be required to generate a new snapshot before you can synch.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 23, 2011 at 10:51 am
If this is an interview question, I second what Dan said. Read up on replication so you can learn enough to get by.
But if I'd been asked that question in an interview, my response would have been "Why are they out of synch? Was it a manual intervention or did something break?" before giving them any sort of solution.
March 23, 2011 at 12:36 pm
Depending on the cause and the size of the table you could use tablediff.exe.
Usually here.
C:\Program Files\Microsoft SQL Server\90\COM\tablediff.exe
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply