Publishing a subscriber...

Hello...
I am looking to see if it is possible to publish a subscriber... so i have
the following:
publisher -> distributor -> subscriber
What I want is
publisher -> distributor -> subscriber (now a publisher as well) ->
distributor -> new subscriber
Is this possible? Has anyone had experience with this? All servers are SQL
Server 2000.
Please advise...
Thanks,
Brett
Brett,
please have a look here:
http://www.replicationanswers.com/Republishing2005.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||It is possible, and infact recommended when you are using merge replication.
However you should ensure that the remote distributor is clustered as this
introduces a single point of failure.
Remote distributors are more critical in high volume transactional
replication topologies. They are unnecessary in merge replication.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Brett Davis" <sqlsquirrel@.msn.com> wrote in message
news:efumTHWRHHA.3412@.TK2MSFTNGP02.phx.gbl...
> Hello...
> I am looking to see if it is possible to publish a subscriber... so i have
> the following:
> publisher -> distributor -> subscriber
> What I want is
> publisher -> distributor -> subscriber (now a publisher as well) ->
> distributor -> new subscriber
> Is this possible? Has anyone had experience with this? All servers are
> SQL Server 2000.
> Please advise...
> Thanks,
> Brett
>
|||On Jan 31, 12:01 pm, "Brett Davis" <sqlsquir...@.msn.com> wrote:
> Hello...
> I am looking to see if it is possible to publish a subscriber... so i have
> the following:
> publisher -> distributor -> subscriber
> What I want is
> publisher -> distributor -> subscriber (now a publisher as well) ->
> distributor -> new subscriber
> Is this possible? Has anyone had experience with this? All servers are SQL
> Server 2000.
> Please advise...
> Thanks,
> Brett
Brett;
I've got about 90 databases set up similar to this:
Publisher/Distributor -> Subscriber -> Distributor -> Subscriber
One thing that affected me is when setting up conflict resolution, I
had to select the decimal Priority figure before it would let me set
this up. This may just be because my publishers are using the desktop
version of MSSQL2K.
Another item that I am currently having trouble with is schema
changes. When I use the appropriate stored procedures to alter
tables, and then I restart the snapshot agent on the publishers, the
changes are propagated to the first subscriber, but they don't make it
to the second subscriber. I need to start another thread about
that. ;)
-Joseph