Fixed Cannot Drop The Database Because It Is Being Used For Replication Microsoft Sql Server Error 3724 Tecadmin

Solution 1:

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. After executing the above T-SQL statement, you can remove your database.

Solution 2:

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.