May 13, 2005 at 3:42 pm
I am restoring replicated databases on a new server which is not connected to current production server anyway. I have replication creation script that I am going to run on the new server to configure replication on new server. my question is how do I synchronize replicated data and how do I make sure it is synchronized with subscribers. Just right clicking on subscription and then choosing start synchonizing would be good enough or have to use sp_article_validation to validate it.
thanks,
May 16, 2005 at 8:00 am
This was removed by the editor as SPAM
May 18, 2005 at 2:22 am
It all depends what is in your script. If it creates the distributor, adds a publication and adds a subscription, all you'll need to do is run the snapshot agent then run the distribution (snapshot/transactional) or merge (merge) agent. It's difficult to tell from your post, but if you're interested in nosync initializations, have a look here: http://www.replicationanswers.com/NoSyncInitializations.asp.
HTH,
Paul Ibison, SQL MVP
Paul Ibison
Paul.Ibison@replicationanswers.com
May 19, 2005 at 5:10 am
It depends on how the original publication was created. If it was a nosync one, then this'll be the same and you'll have to synchronize the data first, or alter it to be synchronized. If it the script is not nosync then the snapshot will contain all the data and the subscriber tables will be dropped and overwritten. If you have subscriber data which is needed on the publisher, you could use DataCompare (Redgate) before setting this up.
Rgds,
Paul Ibison, SQL MVP
Paul Ibison
Paul.Ibison@replicationanswers.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply