Replication Enhancements

SQL Server 2008 introduces a number of usability and manageability enhancements for peer-to-peer replication and the Replication Monitor.

Peer-to-peer replication includes the following significant usability and manageability improvements:

• A new option, enabled by default, that allows the Distribution Agent to detect conflicts during synchronization and to stop applying changes at the affected row.

• The capability to add nodes to a replication topology without quiescing the topology.

• The capability to configure a topology visually in the Configure Peer-to-Peer Topology Wizard. The Topology Viewer enables you to perform common configuration tasks, such as adding new nodes, deleting nodes, and adding new connections ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.