disable replication problem - sql server 2000

Hello,
I need to relocate the Distribution DB, and I was advised that I need to
stop/disable replication to do this. I looked up this article on disabling
replication:
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog03.mspx
which says (near the bottom of the article) that I need to right click on
Replication and then to select Disable publishing and follow the wizard. I
could not find that selection. I right-clicked on Replication Monitor, right
clicked on Publisher, ... I did find in properties on dropping the
publication to stop replication.
How can I stop/disable replication temporarily so I can move the
distribution DB? Is it possisble to stop/disable replication without having
to drop anything? the publication...? How to accomplish this?
Thanks,
Rich
Hmmm, I am stressing too much about this. I saw the replication icon and the
disable selection. My stress is that I have to drop everything and it sounds
like I then have to recreate it all.
Is there a way to save the publication to a script so that I can run the
script to recreate the publication? Or do I have to recreate it from scratch?
"Rich" wrote:

> Hello,
> I need to relocate the Distribution DB, and I was advised that I need to
> stop/disable replication to do this. I looked up this article on disabling
> replication:
> http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog03.mspx
> which says (near the bottom of the article) that I need to right click on
> Replication and then to select Disable publishing and follow the wizard. I
> could not find that selection. I right-clicked on Replication Monitor, right
> clicked on Publisher, ... I did find in properties on dropping the
> publication to stop replication.
> How can I stop/disable replication temporarily so I can move the
> distribution DB? Is it possisble to stop/disable replication without having
> to drop anything? the publication...? How to accomplish this?
> Thanks,
> Rich
|||Rich - just right-click the publication and get Enterprise Manager to create
the script. Also you can use SQLDMO to generate the script for a backup:
http://www.replicationanswers.com/Script7.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Thank you. I feel much better now .
"Paul Ibison" wrote:

> Rich - just right-click the publication and get Enterprise Manager to create
> the script. Also you can use SQLDMO to generate the script for a backup:
> http://www.replicationanswers.com/Script7.asp
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
>