Unable to recreate DB mirroring

Question

"SharePoint_config" DB is displayed in suspended state, such as SharePoint_Config(Principal, Suspended), SharePoint_Config(Mirror, Suspended, Restoring...)

The error occurred when I deleted and re-new the mirroring according to the following steps:

1. Deleted the mirror on Principal DB
2. The status of Mirror DB changed to Disconnected/ In Recovery, that is, SharePoint_Config (Mirror, Disconnected/ In Recovery), but when I deleted the Mirror DB, the following error occurred: "The database 'SharePoint_Config' is enabled for database mirroring. Database mirroring must be removed before you drop the database."

What is the cause for this error? Also, when I delete the mirror on Principal DB, the status of Mirror DB should change to "Restoring..." instead of becoming Disconnected/In Recovery. Why does this behavior occur?

Answer 1

Hi @Kyle Zhan

Database mirroring must be removed before you drop the database

Typically, it indicates that the database you're trying to delete is still in a mirrored state.

Also, when I delete the mirror on Principal DB, the status of Mirror DB should change to "Restoring..." instead of becoming Disconnected/In Recovery.

Normally, after removing mirroring on the Principal DB, the Mirror DB should move to Restoring state. Then you would be able to drop the database without encountering the error.

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".