Replication of replicated database

• Sisir Kumar De

  SSC Enthusiast

  Points: 124

  More actions

  March 24, 2008 at 1:59 am

  #185466

  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.

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  March 25, 2008 at 6:20 am

  #793421

  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