Thursday, November 20, 2014


Cannot drop the database because it is being used for replication.

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 back up  of the same and forced restore over this database.




Press Ok.

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

To learn more about MVC please go to the following link.
MVC Articles

ThanksEnjoy Coding and ReadingSmile


Post a Comment