Post reply

In SQL 2008 Standard Edition - using Transactional Replication - Am I able to replicate A to B, and B to C, daisy chain?

  • February 14, 2013 at 11:36 am

    #270824

    I have a database in production currently replicating to a second server using transactional replication, I'd now like to replicate this database on the second server into a third server. Is this possible to daisy chain the replication of the same database across three servers, or is this a no no. Should I instead of be replicating A to B, and A to C?

    Thanks,

    Kyle

  • February 14, 2013 at 2:03 pm

    #1588115

    Hi,

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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply