Home Forums SQL Server 2008 SQL Server 2008 High Availability In SQL 2008 Standard Edition - using Transactional Replication - Am I able to replicate A to B, and B to C, daisy chain? RE: In SQL 2008 Standard Edition - using Transactional Replication - Am I able to replicate A to B, and B to C, daisy chain?

  • August 23, 2013 at 4:59 pm

    #1644612

    SqlSWAT (2/14/2013)

    It is better to have multiple subscribers rather than setting up daisy chain setup.

    Hi SqlSWAT,

    Why do you say so? What factors play into the decision, etc? I'd appreciate any additional info or background you can give.

    (Sorry to resurrect this old thread, but I'm facing the same choice with my own application's databases, and have had trouble finding advice one way or the other.)

    Thanks,

    -Jason