FIX ERROR – MS SQL: The database 'YOUR_DB_NAME' is enabled for database mirroring.

The following error occurred while trying to delete the database in MS SQL:

The database 'YOUR_DB_NAME' is enabled for database mirroring. Database mirroring must be removed before you drop the database.

 

Solution:

ALTER DATABASE "YOUR_DB_NAME" SET PARTNER OFF;
GO

DROP DATABASE "YOUR_DB_NAME";
GO

Tagged: Tags

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments