September 20, 2006 at 5:29 am
We have a DL585 cluster that acts as a publisher for mutiple subscribers (cluserver). There is another server (distrib) that acts as the distributor for cluserver. distrib is running out or resources as there are too many publications for it too deal with so I have setup a new DL385 (distrib1) to act as the new distribution server.
What i need to know if anyone knows an easy method to move the distribution database to the new server.
What i was thinking of doing is scripting all jobs>Removing replication totally> the setting up new server as distribution server> and then rescripting jobs.
Can anyone give me a step by step proven process or do they know of one on the web?
thanks
September 20, 2006 at 8:42 am
Generating the drop and add scripts is simple, merely right-click in Enterprise Manager on the replication publication in question and select Generate SQL Script.... You can use the included Preview button to see what the script will look like before you generate it.
Just be sure that you (assuming you're doing transactional replication) have stopped all activity on the publisher databases and allowed any pending transactions to be distributed to subscribers before running the scripts to drop replication. Otherwise you will "lose" data, i.e. the publisher will have data changes that the subscribers do not.
If this kind of down time is not acceptable, then perhaps someone else can tell you how to switch distributors "on the fly". I'll be interested as well.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply