Why Is an Error Reported When I Attempt to Delete a Database from RDS for SQL Server Primary/Standby DB Instances?
Symptom
The error shown in Figure 1 is reported on SQL Server Management Studio when a database is being deleted from RDS for SQL Server primary/standby DB instances.
The database 'database_name' is enabled for database mirroring. Database mirroring must be removed before you drop the database. Error: 3743
Possible Causes
The error details indicate that the RDS for SQL Server DB instance type is primary/standby and database mirroring is enabled for the standby DB instance. As a result, the database cannot be deleted.
Solution
Before deleting the database, run the following commands to disable the mirroring:
Use master
go
ALTER DATABASE [database_Name] SET PARTNER OFF;
GO
Once database mirroring is disabled, the database can be deleted.
Database Usage FAQs
- Does MySQL 8.0 Support Full-Text Search?
- How Do I Use DAS to Query SQL Statements?
- How Do I Use the mysqlbinlog Tool?
- How Do I View Session IDs and Login and Logout Time of a Database?
- How Do I Create a Scheduled Task?
- What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
- Does the OPTIMIZE TABLE Operation Lock Tables on an RDS DB Instance?
- Why Is an Error Reported When I Attempt to Delete a Database from RDS for SQL Server Primary/Standby DB Instances?
- What Should I Do If My root Account Was Deleted by Mistake?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore