Publishing Subscriber

  • I have 1 Server called Fred as a Distributor/Publisher. There is a Database called SSM that is Published.

    I also have another Server called Barny that is a Susbcriber. It Subscribes to the Publication Database (SSM)from Fred.

    Is it possible to Re-Publish the SSM Database that is on Barny to Wilmur?

    According to BOL, you can! If you type in Publishing Subscriber in BOL you will see a diagram that depicts this.

    My qeustion is, how do you do it? How do I Re-Publish an already Subscribed Database to other Subscribers?


    Kindest Regards,

  • I'm not sure if I understand you correctly. I have a similar situation: Server A publishes a db, Server B is subscriber to A, and server B itself is a publisher to server c, which is subscriber to server B. You create this the same way you do any publication: choose Tools> Replication>Create publication.

    Haven't you tried this? Or do I miss something here?

    Greetz,
    Hans Brouwer

  • I'll give it a go.

    I wasn't aware that you can Re-Publish an already Subscribed Database!


    Kindest Regards,

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply