November 10, 2014 at 2:50 am
Hi All,
I have one doubt on Replication.
If i have configured Transactional replication with 3 subscribers after some time one subscriber is not connecting due to any reason but other subscribers are able to get the data properly from publisher.
After one week we have fixed that subscriber issue. now i want to get the one week data to that subscriber.. is there any possible without re-creating the subscriber.
November 18, 2014 at 7:34 am
if the Subscriber (with the missing data) is now active and receiving new inserted data ok, then you can manually insert the missing data from the Publisher database without breaking replication. However, if you could take an outage at that Subscriber and your replicated dataset is not too large then I would recommend you re-initialize and resnapshot the data just to that Subscriber.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply