All geek questions in one place

Unable to delete Amazon RDS SQL Server database

I made a mistake in the database naming scheme on the Amazon RDS SQL Server instance, but you do not have permission to delete it.

http://i.imgur.com/LXer7EW.png

Can anyone give me any guidance?

thanks

+7
source share
4 answers

Found the answer, if you change the user privileges by resetting the instance password, the user rights will also be reset

+9
source 
-- 1. Turn Database Mirroring OFF ALTER DATABASE [DB_NAME] SET PARTNER OFF; GO -- 2. Close all existing connections ALTER DATABASE [DB_NAME] SET single_user with rollback immediate GO -- 3. Drop the database DROP DATABASE [DB_NAME]; GO
+2
source

None of these options worked for me. The result was a change in collection data. Once I disabled this by running the command

 exec msdb.dbo.rds_cdc_disable_db '<database name>'

I managed to drop the database.

0
source 
 EXECUTE msdb.dbo.rds_drop_database '<dbname>'
0
source

Source: https://habr.com/ru/post/979339/

More articles:


All Articles