question

Chitrarekha avatar image
Chitrarekha asked

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][1] [1]: /storage/temp/381-distributorerror.png
replication
distributorerror.png (9.1 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Cyborg avatar image
Cyborg answered
can you please check you followed the steps mentioned http://support.microsoft.com/kb/324401
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Chitrarekha avatar image Chitrarekha commented ·
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?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.