Hello,
I have a small three server development environment where I am getting my feet wet with replication. I have set up peer-to-peer transactional replication and it works fine for data added to the publication's table after the publication was created. However, rows in the table that existed prior to the publication's creation have never replicated. If any of the "old" rows are edited they cause an error on the subscribing servers when the replicator attempts to apply updates to rows that do not exist.
How can I get the old rows that predate the publication to replicate?
Thanks,
BCB
I believe to setup peer-to-peer replication, you'll need to initialize the data at each node through backup and restore. You can find more info here.
http://msdn2.microsoft.com/en-us/library/ms146914.aspx
Gary
No comments:
Post a Comment