Sometimes I face issues with the database deletion in the SQL server. If we have configured replication in the database previously. In that case, when I try to remove the database it gives me the following error.
Cannot drop the database ‘Test_db’ because it is being used for replication. (Microsoft SQL Server, Error: 3724)
Use the sp_removedbreplication stored procedure to remove all the replication objects on the publication and subscription databases.
Make sure to change the database name “Test_db” with your database name.
DECLARE @subscriptionDB AS sysname SET @subscriptionDB = N'Test_db' USE master EXEC sp_removedbreplication @subscriptionDB GO
After executing the above T-SQL statement, you can remove your database.
Create a database with the same name on another SQL server instance. Then create a full backup of the database. Now restore the database to this server forcefully.
To restore the database forcefully, make sure to select the “WITH REPLACE” option
Now you can remove the database from the SQL Server.