Cannot drop the distribution database

Used the following method to drop distribution database use master go alter database distribution set offline; drop database distribution;

I no longer have distribution database listed in the system databases. However when I try to create a distribution database, rt click on the replication, cannot configure distribution database, but it is showing Distributor Properties. Also in Microsoft SQL Server folder\Data distribution database is existing also the distribution databse jobs are existing. Please advice how I can delete distribution database.alt text

more ▼

asked Aug 30, 2012 at 04:01 PM in Default

avatar image

140 37 42 45

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

can you please check you followed the steps mentioned http://support.microsoft.com/kb/324401

more ▼

answered Aug 31, 2012 at 05:35 AM

avatar image

10.8k 37 54 51

I have followed the link above but the issue is I have not followed the steps of removal. I deleted the publisher and subscriber by hand instead of running disable publishing and distribution. I also deleted the distribution database by hand which did not delete the distribution database from the data folder. So any way do I uninstall and install sqlserver again?

Aug 31, 2012 at 01:42 PM Chitrarekha
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 30, 2012 at 04:01 PM

Seen: 2819 times

Last Updated: Aug 31, 2012 at 01:42 PM

Copyright 2016 Redgate Software. Privacy Policy