Database mirroring must be removed before you drop SQL Server database – Error 3743

If you try to drop a mirrored database in SQL Server before you remove mirroring you will get the following error:

Msg 3743, Level 16, State 1, Line 1
The database ‘Database_Name’ is enabled for database mirroring. Database mirroring must be removed before you drop the database.

drop_mirrored_database_error

You need to disable mirroring before deleting the database.
To disable mirroring run the following code:

ALTER DATABASE [Database_Name] SET PARTNER OFF;
GO

Now the database mirroring is removed and you will be able to drop the database.

If the post helped you, please share it:
Pin It

2 comments to Database mirroring must be removed before you drop SQL Server database – Error 3743

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">