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
Author
Message
Posted Friday, May 28, 2010 7:25 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, January 17, 2016 11:34 PM
Points: 18, Visits: 175
Hello,

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


G.
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.

Cheers,
Satnam
Post #1058513
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse