Cannot drop the database because it is being used for replication

Cannot drop the database because it is being used for replication from one server to another in SQL server 2008.

I have confronted an error during replication from one server to another in SQL server 2008 R2. I confronted this error when I was disabling publishing and distribution as depicted below in image :

                                 

This error generally occurs when you have deleted the publisher database and due to some cause it didn’t delete from masters database. Though best practice is always “Disable publishing and Distribution”.

The workaround of this problem is: Create a database with same name and another server or instance. Take backup of the same and forced restore over this database.

 

 

Press Ok.

Thanks for reading this article and hope it will sort your issue.

Warm Regards

Sachin Kalia