January 16, 2003 at 1:02 pm
We have disable Replication but the Distribution DB remains and thinks it is still involved with replication and I need to drop it. I get an error when I try to manually drop the distribution DB. Does anyone have a work around for this.
January 16, 2003 at 3:06 pm
See if this helps
from BOL
quote:
How To Disable Publishing and Distribution (Transact-SQL)To disable a Distributor (Transact-SQL)
Execute sp_dropdistpublisher to drop a Publisher that is also the Distributor.
Execute sp_dropdistributiondb to delete the distribution database.
Execute sp_dropdistributor to remove the Distributor designation from the server.
To delete a distribution database (Transact-SQL)
Execute sp_dropdistributiondb to delete a distribution database.
To manually remove replication on a Publisher without connecting to the Distributor (Transact-SQL)
Execute sp_dropdistributor with @no_checks=1 and @ignore_distributor=1.
January 16, 2003 at 6:38 pm
We try that and it still didn't help. We finally had to update the sysdatabases table to say it wasn't involved with replication and then we were finally able to delete it.
Thanks for the reply
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply