Amazon Relational Database Service
User Guide (API Version 2014-10-31)

Dropping a Microsoft SQL Server Database in a Multi-AZ with Mirroring Deployment

You can drop a database on an Amazon RDS DB instance running Microsoft SQL Server in a Multi-AZ deployment using Mirroring. You can use the following commands:

ALTER DATABASE <database_name> SET PARTNER OFF; GO DROP DATABASE <database_name>; GO