Back
I tried to migrate a SQL Server database by Export Data-tier Application (.bacpac file) from an Amazon RDS instance to others, but import didn't succeed. So now I want to delete the database (which is empty) when I try to:
DROP DATABASE mydatabase;
I get the error:
Cannot drop the database 'mydatabase', because it does not exist or you do not have permission
Some context:
We can use the RDSadmin rename function to change it to something else, this seems to fix the issue and allows you to drop it.
EXEC rdsadmin.dbo.rds_modify_db_name N'<OldName>', N'<NewName>'
Use this to just drop the DB.
Learn how we helped 50,000+ professionals like you !
31k questions
32.8k answers
501 comments
693 users