469,106 Members | 2,258 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

Cannot Drop Database

I am trying to drop a database, but keep getting the following error.

"cannot drop database 'blah' because it is currently being used for
replication".

This db is not currently being replicated, but once was. It is the
subscriber side of an old replication pair.

Can anyone tell what I have to do to make this go away?

Thanks,

TGru

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 23 '05 #1
1 1946
Hi

Have you checked that all the replication information has been removed?
See sp_removedbreplication in Books online and/or search Google/MSDN for
"Remove Replication"

John
"tgru" <tg**@devdex.com> wrote in message news:42**********@127.0.0.1...
I am trying to drop a database, but keep getting the following error.

"cannot drop database 'blah' because it is currently being used for
replication".

This db is not currently being replicated, but once was. It is the
subscriber side of an old replication pair.

Can anyone tell what I have to do to make this go away?

Thanks,

TGru

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by BashiraInTrouble | last post: by
7 posts views Thread by Wayne Brantley | last post: by
4 posts views Thread by Michael C | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.