Help Center > > FAQs> Product Consulting> Why an Error is Reported When I Attempt to Delete a Database from RDS SQL Server Primary/Standby DB Instances?

Why an Error is Reported When I Attempt to Delete a Database from RDS SQL Server Primary/Standby DB Instances?

Updated at: May 26, 2020 GMT+08:00

Symptom

An error shown in Figure 1 is reported on SQL Server Management Studio when a database is being deleted from RDS SQL Server primary/standby DB instances.

The database 'xxxx' is enabled for database mirroring.Database mirroring must be removed before you drop the database. Error: 3743

Figure 1 Error information

Possible Causes

According to the error information, the 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

After the database mirroring is disabled, the database can be deleted.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel