Replication with Database Mirroring

• Alex Webber

  SSCommitted

  Points: 1543

  More actions

  January 27, 2011 at 10:25 am

  #232890

  If you want to aggregate data using transactional replication from 1 table whose rows are split over two mirrored databases, how do you avoid the distribution database (which can't be mirrored) from being a single point of failure?

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  January 28, 2011 at 11:17 am

  #1279849

  Clustering

  
  
  A.J.
  DBA with an attitude