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

SQL 2008 R2 Replication help Expand / Collapse
Author
Message
Posted Tuesday, January 1, 2013 6:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 3, 2013 7:25 PM
Points: 1, Visits: 1
We have two separate production db servers whose only difference is data content. We are trying to publish the data from each server to a single separate distribution server (separate distrib dbs) and then replicate all the data to tables named by server on a third remote subscriber box.

We were successful at setting up the first distributor, publication and subscription using t-rep. However, when setting up the second server publication and subscription the new one is taking over and the first one stops running.

What am I doing wrong?
Post #1401591
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse