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

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: Wednesday, October 8, 2014 11:25 PM
Points: 14, Visits: 152
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