Answered by:

hai all

Question

consider a scenario where in replication, when the publisher database gets unavailable, that time we can insert/update/delete data into subscriber database i think. Now my question is what all the data modifications we do in subscriber database how will
it gets sync to the publisher databases in replication?

All replies

Depends on the type of replication you're referring to. If you're using Merge replication then changes on either end will be sync'd without any special setup, but if it's Transaction replication then those changes to the subscriber database won't be replicated
back to the publisher. There may be ways to get transaction replication going in both directions but that would require additional work.

In replication, when the publisher database gets unavailable, there are some suggestions to get sync from the subscriber database to the publisher databases.

1. We can back up the subscriber database and copy the backup to the publisher and restore it there with a different name than the publication database name. And then configure the replication again.
2. If this is merge replication and the backup you have of the publisher database is within the retention period, merely restore it with the keep_replication switch. The Subscriber will backfill the publisher with missing rows.

Publisher in replication is your main database and subscriber is replicated database. We are not sure of which replication you are using. But my suggestion is NOT to update the article in subscriber unless there is a valid reason. First point is that your
subscriber may or may not be taken as publisher. Because, you may be altering your key table indexes in subscriber to boost the performance for queries running on subscriber. Hence considering your subscriber later as publisher, your queries might hurt. It
all depends how do you use your subscriber and the replication strategy you configured.

First of all, you need to find what stops your replication and act on it.

Please use Marked as Answer if my post solved your problem and use
Vote As Helpful if a post was useful.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.