December 30, 2008 at 1:35 am
I have a five server at different sites. and replicated through transactional replication . but if i join new server to the central server through transactional replication it replace old data. how can i protect my old data and join a new server through transactional replication.
December 30, 2008 at 4:56 am
Hi,
Do you mean "Replace old data" - Replacing the data at the new server (new subscriber), then it would definelty replace the old data, because any type of replication is followed by first applying the snapshot of the selected articles in the replication.
Incase if you have selected a particular table\object as an article for transation replication then that table\object would be dropped and then recreated at the subscriber end for the first time. Which means first time a snapshot of the publisher is copied to the subscriber and then the data gets syncronised by applying the transaction logs there after.
Hence you cannot stop it from happening. Advisable to take a backup incase if you require the old data.
-Rajini
December 30, 2008 at 5:01 am
hi, yeh this can be happen for first time of transactinal replication it will copy of your old data as snapshot and restore that into your new server instead of that you can do this snapshot process of copying data.
Raj Acharya
December 30, 2008 at 5:05 am
hi sory please ignore previous one... i want to say that it's replacing your data with old data that because of first step of snapshot taken by process you can directly restore that data manually and start process of transactional replication without snapshot
Raj Acharya
December 30, 2008 at 5:27 am
raj acharya (12/30/2008)
hi sory please ignore previous one... i want to say that it's replacing your data with old data that because of first step of snapshot taken by process you can directly restore that data manually and start process of transactional replication without snapshot
It can not achived ,
bec whenever u create new subscriber , snapshot agent is start, take a snaphot of publisher data and copy it to subscriber. so ur old data will be replace.
December 30, 2008 at 6:42 am
hi,
mr paresh lasan
be pela e su keva mange che eto samaj....
call me i will explain you ok Mr.Enderson remember...
call me i will explain you how to do that
Raj Acharya
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply