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

Replication of replicated database Expand / Collapse
Author
Message
Posted Monday, March 24, 2008 1:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 25, 2008 1:26 AM
Points: 12, Visits: 51
Is it possible to replicate the replicated database to a distant server. If yes, what are the steps to be followed? We are replicating a database from Server 1 to Server 2. We want to replicate the same replicated database from Server 2 (not from Server 1) to a distant server 3.
Post #473373
Posted Tuesday, March 25, 2008 6:20 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, February 10, 2014 1:53 AM
Points: 1,219, Visits: 672
Hi,

So Server 1 is currently a publisher and Server 2 is a subscriber...correct.

Once these are in place you can simply republish the data on Server 2 and add the remote server as a Subscriber to the Server 2 Publication.

Should be straighforward :)

Regards
Graeme



Post #473985
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse