August 31, 2009 at 12:26 pm
Hello Experts,
New to the Replication process. Expert and detailed advice needed.
I have a Transactional replication setup. Was trying to add an article to my already setup replication, in the process, i set the snapshot for re-initialization (wrong move i guess), was hoping i could reverse the process by conttinuing with the replication process without re-initializing. Is this possible?? If it is, what is the best way to go about it???
Any assistance will be very much appreciated.
August 31, 2009 at 1:37 pm
When you add a new article to an existing publication and set for Snapshot initialization, it will do it only for that article. Nothing else.
-Roy
August 31, 2009 at 1:43 pm
Thanks Roy for your prompt response. In essence, nothing can be done to reverse the process?? Could you explain to me stepwise how an article can be added for replication, without re-initialization (Sql server 2005 - Transactional Replication). I believe this is possible.
August 31, 2009 at 2:27 pm
I am not so sure if you can get away from reintialization of snapshot if you are adding the article to an existing Publication where the data was synched using snapshot.
-Roy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply