Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

In SQL 2008 Standard Edition - using Transactional Replication - Am I able to replicate A to B, and B to C, daisy chain? Expand / Collapse
Author
Message
Posted Thursday, February 14, 2013 11:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 6:07 AM
Points: 2, Visits: 32
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
Post #1420231
Posted Thursday, February 14, 2013 2:03 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 7:20 AM
Points: 38, Visits: 432
Hi,
It is better to have multiple subscribers rather than setting up daisy chain setup.
Post #1420292
Posted Friday, August 23, 2013 4:59 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 8:56 AM
Points: 43, Visits: 376
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
Post #1488068
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse