Sunday, March 25, 2012

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!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" <tgru@.devdex.com> wrote in message news:4225fcc4$1_1@.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!

No comments:

Post a Comment