February 28, 2014 at 12:58 pm
Hi All,
We have peer-to-peer transactional replication setup between 3 territories having SQL server 2008 R2 Sp2 version.It has been identified that the data is not in sync in three environments for last few months.
The biggest challenge here is that now we have data changes applied at each territory.Even to rebuild replication and without data-loss, we would need to merge the data from all three territories at one location and then reinititialize with new backup of merged database.
We have tried the tablediff utility.however, it doesn't include the scripts for XML datatype columns.
Can anyone please help us how to proceed in such situation?
Thanks
March 1, 2014 at 1:48 pm
How much data are you talking about? A couple million rows or hundreds of millions? If the lesser you could create an ancillary table to hold the "proper set of data", construct a process to extract the correct records from each territory, then insert the final result into the new table.
What's the status of the first node (your original publication database)? I assume you configured the other 2 nodes based upon a backup of the first...so in theory the first node should still have the correct data? Or are you saying that all 3 nodes a out of sorts?
I don't know what method you have in place to detect the conflicts between peers, but after you have cleared this up you may want to review this article: http://technet.microsoft.com/en-us/library/bb934227(v=sql.105).aspx
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply