Advice on replication
Posted on 2005-05-13
We have one server (server1) that hosts a website that backs on to a sql server database sitting on the same machine.
In the event of a machine failure, the website will failover to another server (server2). There is a sql server database that sits on this server as well.
We upload data to the sql server on server1 several times a week. At the moment if server1 is down (which it has been intermittently over the past 6 months) we stop uploading data untill server1 is back up again so that the databases dont get out of sync. Ideally, whichever server is up, we want to be able to continue uploading data and be sure that when the other server comes back, it will sync the dbs so that all data will be current.
We have used snapshot replication so far to keep the dbs on each server in sync but there seems to be an issue with snapshot rep when the db is being served off server2. So we plan to stop using it.
Does merge replication fit this scenario? Will merge rep automatically sync the dbs when a server comes back on line. If not is there a better suggestion?