sql server replication: 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 .

[quoted text, click to view]

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

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



[quoted text, click to view]