x

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

Chitrarekha gravatar image

Chitrarekha
140 32 42 43

(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

Cyborg gravatar image

Cyborg
10.6k 36 40 45

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x304

asked: Aug 30, 2012 at 04:01 PM

Seen: 1738 times

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