We have 3 servers using sql 2005 having merge replication setup. If we use 1 publisher and 2 subscribers approach, can this replication topology handle single point of failure(i.e. when publisher server is down or not available, can the remaining 2 subscribers synchronize with each others?). If this approach cannot handle single point of failure, is there any other replication setup that can handle single point of failure and able to resolve conflicts for 3 servers using sql 2005?
Thanks and regards,