sql server replication: Adding one more subscriber -- sql server replication

Adding one more subscriber

Aris
10/29/2005 2:33:03 AM

sql server replication:

Hi All

I have a transactional replication with one publisher/distributor and one
subscriber. I want to add one more subscriber for another location. What is
the best method to add one more subscriber? Expect expert's suggestions.

Regards,
Aris

Re: Adding one more subscriber

Hilary Cotter
10/29/2005 12:38:58 PM

Make sure the new subscriber is enabled (use Tools, Replication, Configure
Distributor, Publishers and Subscribers).

If it is indistinguishable from the other subscriber simple script out your
publication, note the sp_addsubscription statement at the bottom, copy this
and paste it into your publication database on your publisher. Edit this
statement for the new subscriber.

Run the script.
--
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]