Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

2 distribution on same sql server instance Expand / Collapse
Posted Friday, May 28, 2010 7:25 AM



Group: General Forum Members
Last Login: Friday, February 19, 2016 5:21 AM
Points: 19, Visits: 178

I have a replication transactional in real time, and i want to create another replication (merge) on SQL Server Standard Edition SP1.
Is posible to create the second distribution (database) for merge replication (for more redundance) on the same SQL Server 2005 instance?

tks. in advance

Post #929664
Posted Thursday, February 3, 2011 11:33 PM

SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 6, 2014 1:47 AM
Points: 292, Visits: 1,084
You can have it but having two distributors on the same server where the publisher is located will definitely have an impact on the performance of the system.

Post #1058513
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse