Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » SS2K5 Replication » 2 distribution on same sql server instance
Add to briefcase

2 distribution on same sql server instance Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
gbastea
Posted Friday, May 28, 2010 7:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 5:00 AM
Points: 13, Visits: 112
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
Satnam Singh
Posted Thursday, February 03, 2011 11:33 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 5:14 AM
Points: 291, Visits: 1,066
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.