October 30, 2003 at 10:18 am
I have SQL Server 2000 snapshot replication setup with one publisher, one distributor, and four subscribers.
I want to replace one fo the subscribers with a new server. It will have the same network name, same IP......
How do I enable replication on this new box?(make it a subscriber and subscribe to the publication)?
(alot of details please)
October 30, 2003 at 12:03 pm
Does this look right:
1. On "new" Subscriber: restore a copy of the subscriber DB.
2. On Distributor:
Go to Replication, Publications...delete the subscription.
3. On Distributor(Publisher database): run these...
-- Adding the registered subscriber
exec sp_addsubscriber @subscriber = ...............
-- Adding the snapshot subscription
exec sp_addsubscription @publication = , @subscriber = ..........
will that work?
anything else?
November 3, 2003 at 7:04 pm
In my experience I usually just drop the subscription and recreate it in EM. But then, I'm lazy when it comes to the Snapshot replication.
Or you can use EM to script out the snapshot and then run the script on the appropriate server when you need to.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply