June 9, 2009 at 2:54 pm
Our replication failed. I want to restart the replication with a new snapshot. What does SQL 2005 do with the data already on the tables in the subscriber database? Does it compare and make required changes? Does it delete the existing data and reload? Does it add the publication data to what is existing thus duplicating some data?
I have been unable to find any information on the internals of how this works.
June 10, 2009 at 5:44 am
Carl Sorgenfrie (6/9/2009)
Our replication failed. I want to restart the replication with a new snapshot. What does SQL 2005 do with the data already on the tables in the subscriber database? Does it compare and make required changes? Does it delete the existing data and reload? Does it add the publication data to what is existing thus duplicating some data?I have been unable to find any information on the internals of how this works.
Hi Carl,
Whenever you generate a new snapshot the snapshot agent will recreate all the table definitions and data etc.. to the distributor. And from there it gets delivered to the subscriber. And all the existing data will be deleted and if there are any changes in the table definitions the tables will be recreated. You can refer to Apress Pro SQL Server 2005 Replication written by Sujoy Paul for internals of replication.
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
June 10, 2009 at 7:00 am
After doing much searching last night I did some testing that provided the same answer. Thanks for your reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply