Microsoft SQL Server: The database is enabled for database mirroring. Database mirroring must be removed before you drop the database. (Microsoft SQL Server, Error: 3743)

Wednesday, August 7, 2013

The database is enabled for database mirroring. Database mirroring must be removed before you drop the database. (Microsoft SQL Server, Error: 3743)

The database is enabled for database mirroring. Database mirroring must be removed before you drop the database. (Microsoft SQL Server, Error: 3743)

Workaround

1. Disable Mirroring
2. Remove endpoints
3. Drop databases

If database mirroring is failed while doing configuration it wont allow you drop the database on mirror server directly, follow the below steps to drop the mirroring

Alter database database_name set partner off     -- Disable mirroring

restore database database_name with recovery    -- Bring database to online

drop database database_name     -- To drop database from instance

No comments:

Disclaimer

This is my personal blog, the views and opinions are published here are my own. All data and information provided on this site is for informational purposes only. The views and opinions expressed here are of my own and not those of the people or organizations that I may or may not be related with. The code / scripts or any kind of stuff published in this blog are not permitted or certified by my employer or Microsoft SQL Server. While following any advices from blog if you encountered any issues, author is not responsible for that.