Why an Error is Reported When I Attempt to Delete a Database from RDS SQL Server Primary/Standby DB Instances?
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
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.
Before deleting the database, run the following commands to disable the mirroring:
ALTER DATABASE [Database_Name] SET PARTNER OFF;
After the database mirroring is disabled, the database can be deleted.