though I use sql server 2012, this is the replication forum so I post here.
I have 4 db with replication configuration for let's say 10 articles. Other tables in locations have exactly same schema but their data is specific to location like employee names so they are not replicated.
I will use the simplest and most problem-free backup solution for each of them. First of all its clear that every backup will be full backup. Also I have a luxury to stop sql services in locations and copy database files.
MS documents dives examples like "if merge replication is made in every 10, 20 30 days.. etc". but I use continious merge replication and data is replicated in about 60 seconds.
my question is
1. what do you suggest ?
2. can I use this strategy:
backup each location to their local server with an application like sqlbackupandftp
in this option, I don't know howto restore them one by one and all of them together.
I think, when I need to restore a database, it will be for one location because its almost impossible all 4 sites would have problem at the same time.
when I restore publisher or subscriber, how does it effect other sites ?
any comments or simple step by step sample licks will be appreciated.