here i can see peer-to-peer replication option but this options are not in my SQL 2008 r2 standard edition server. Is this bug?
1 Answer
MSDN article on the topic: Peer-to-Peer Transactional Replication. Fromt he General Considerations section:
Peer-to-peer replication is available only in SQL Server 2008 Enterprise.
-
ok, does it have to be clustering or can be configured without shared storage between two servers ? Jun 1, 2011 at 6:14
-
1@Albert: peer-to-peer replication doesn't have any clustering requirement. Jun 1, 2011 at 6:21
-
Cool that is why I'm interested in using this feature and no witness server necessary too. Jun 2, 2011 at 1:58