Microsoft® SQL Server 2008 R2 Unleashed

Using Replication and Database Mirroring Together

SQL Server 2008 allows you to use combinations of options to achieve higher availability levels. A prime example would be to combine data replication with database mirroring to provide maximum availability of data, scalability to users, and fault tolerance via failover, potentially at each node in a replication topology. By starting with the publisher and perhaps the distributor, you make them both database mirror failover configurations. Figure 20.32 shows a possible data replication and database mirroring configuration (database mirroring of the publisher and database mirroring of the distributor). For further explanation of a transactional replication topology, see Chapter 19, “Replication ...