Replication of replicated database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Replication » Replication of replicated database

Replication of replicated database

Rate Topic

Display Mode

Topic Options

Author

Message

Sisir Kumar De

Posted Monday, March 24, 2008 1:59 AM

Grasshopper

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

Graeme100

Posted Tuesday, March 25, 2008 6:20 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 8:12 AM
Points: 1,209, Visits: 628

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 »

Permissions