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
0 0 vote
Article Rating

Tagged: Tags

Подписаться
Уведомление о
guest
0 Comments
Inline Feedbacks
View all comments