How to delete distibution database in replication

Used the following command but still cannot delete distribution database. Cannot create distribution with the same name.

 use master
 alter database distribution set offline;
 drop database distribution;
more ▼

asked Aug 27, 2012 at 09:42 PM in Default

avatar image

140 37 42 45

What message do you get when you drop the current replication?

Aug 27, 2012 at 11:23 PM sp_lock

Can delete the database using the following command, but when I try to create distribution database error in Distributor Properties, could not add distribution database 'distribution' Additional information:An exception occured while executing a Transact-SQL statement or batch.(Microsoft.SqlServer.ConnectionInfo) Could not add the distribution database 'distribution'/ This distribution database already exists. Changed database context to 'master'.(Microsoft SQL Server, Error : 14119)

Aug 28, 2012 at 01:07 PM Chitrarekha
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
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 27, 2012 at 09:42 PM

Seen: 1245 times

Last Updated: Aug 28, 2012 at 01:08 PM

Copyright 2018 Redgate Software. Privacy Policy