Monday, January 21, 2013

SOLVED: Cannot Drop The Database Because It Is Being Used For Replication. (Microsoft SQL Server, Error: 3724)

ERROR: 
Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)

It usually happened after removing replication, the replicated database was unable to delete and it throws 3724 error. You just follow below steps to delete the database without any error. 

Step 1: To avoid this error create a new database with the same name on different server and take the full backup.

Step 2: Restore the replicated database with newly created full back by selecting option "overwrite the existing database (WITH REPLACE)". follow the screenshot below.


Cannot drop the database XXX because it is being used for replication. Error 3724: Cannot drop the database. Cannot drop the database 'MyDatabase' because it is being used for replication. [SQLSTATE 42000] (Error 3724). . because it is being used for replication. 15051: Cannot rename the table because it is published for replication. If we attempt to detach the database. we get the following error message. Msg 3724. Level 16. State 1. Line 1. Cannot ... Cannot drop the database 'distribution' because it is being used for replication. SQL Server 2012. sql server 2008 r2. sql server 2005.

0 comments:

Post a Comment