Help Center/ Relational Database Service/ FAQs/ Database Usage/ Why Is an Error Reported When I Attempt to Delete a Database from My RDS for SQL Server Primary/Standby DB Instance?
Updated on 2024-05-13 GMT+08:00
View PDF

Why Is an Error Reported When I Attempt to Delete a Database from My RDS for SQL Server Primary/Standby DB Instance?

Symptom

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

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

Figure 1 Error

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.

Parent topic: Database Usage