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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » In SQL 2008 Standard Edition - using...

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

Rate Topic

Display Mode

Topic Options

Author

Message

kyledarrenhanson

Posted Thursday, February 14, 2013 11:36 AM

Forum 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

SqlSWAT

Posted Thursday, February 14, 2013 2:03 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:47 PM
Points: 38, Visits: 334

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

Post #1420292

« Prev Topic | Next Topic »

Permissions