July 11, 2012 at 1:21 pm
I have set up a Merge Replication for the databases used by a specific application. The Publisher is on the Master system and the Subscriber is a child system, which the users can use if the Master system goes down for some reason.
If the server hosting the Publisher goes down, and the users continue their tasks on the server hosting the Subscriber database, what will happen when the Publisher server is brought back up?
Basically, the scenario would be:
1. Publisher server goes down
2. Users switch to Subscriber server, continue work entering data
3. Publisher server is brought back up
4. Restart syncing on the Publisher
Will the data entered in the Subscriber, entered while the Publisher went down, be pushed to the Publisher?
What would be the best way to ensure new records in the Subscriber are not lost when the Publisher is restored?
July 20, 2012 at 8:22 am
Did you check this link?
http://msdn.microsoft.com/en-us/library/ms152497.aspx
It gives you a good idea on what needs to be done and what to try.. It would be a good exercise to simulate some scenarios in a test environment and see the behavior. Good luck
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply