Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Replication (2005)  Which replication type?

Author  Topic  md9547 Starting Member 1 Post Posted - 2009-08-26 : 09:49:34 My site is a fairly large ecommerce deal, and we want to add an additional server behind a load balancer. This server would have a duplicate copy of the database, ideally synchronised in real-time. Initially I looked at the replication types available and Peer to Peer replication seemed the best choice, as each server could update from the other, and if one was to go down, the other would still be available. However, after trying to enable Peer to peer replication, I found that the Enterprise edition of SQL Server is required. Is there a feasible way of achieving what I want to do with Standard edition? It's possible for us to upgrade to Enterprise, but we'd prefer not to if feasible...