I incurred this situation when one of the my test server configured for Transnational replication some time before and now I wanted to restore a fresh database copy on top of it, it failed with error saying 'Database is in use'.
Then I tried working to drop the database. Since it is involved on replication it says 'database cannot be dropped unless you remove the replication'
Then tried removing the replication it says 'the object used for the replication owner is not DBO or you don't have access to remove the replication', though I am trying with sysadmin privileges.
Finally I used one of the system proc 'sp removedbreplication' and passed the Subscriber and Publisher database names as parameters then it got dropped both the subscriber and publisher under Replication Folder.
sp_removedbreplication @publisher
sp_removedbreplication @subscriber
Hope this information helps to remove the replication when it gives you an error !!!!
Then I tried working to drop the database. Since it is involved on replication it says 'database cannot be dropped unless you remove the replication'
Then tried removing the replication it says 'the object used for the replication owner is not DBO or you don't have access to remove the replication', though I am trying with sysadmin privileges.
Finally I used one of the system proc 'sp removedbreplication' and passed the Subscriber and Publisher database names as parameters then it got dropped both the subscriber and publisher under Replication Folder.
sp_removedbreplication @publisher
sp_removedbreplication @subscriber
Hope this information helps to remove the replication when it gives you an error !!!!
No comments:
Post a Comment