May 12, 2010 at 4:49 am
Hi,
I have one database which is involved in Replication. Now that database turned to suspect mode. I am unable to drop that database, and unable to recover also.
Cannot drop database "db_pub" because it is currently in use.
There are no active connection to this database
and I have set is_published to 0 and is_subscirber to 0
My understanding is since these settings are exisitng in distribution database.
How to drop this database ?
thanks
May 12, 2010 at 5:06 am
if the replication is merge or transactional, you will have to stop the agents.
Have you tried dropping the database using the script:
Alter DATABASE yourdb SET OFFLINE
DROP Database yourdb
sb
May 12, 2010 at 5:12 am
Hi,
The replication is transactional. I tried the below statements also, it is still showing the same error
Thanks
May 12, 2010 at 5:18 am
the thing I would try is to drop the subscriptions and stop all agents of distribution. or better, drop the whole replication. Time ago I had a similar problem and solved it dropping the whole replication.
May 12, 2010 at 5:32 am
Dropping the replicatin ? I am not able to see publisher in local publisher folder in Management studio
May 12, 2010 at 5:44 am
if there is still something to drop, even if not 'visible',
running sp_removedbreplication on both the publisher and subscriber
should clean.
Else I don't have any suggestion more...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply