Cara Drop Database di RDS SQL Server

1. Sambung ke RDS SQL Server

Guna sqlcmd dari server (atau PC):

sqlcmd -S akhiran.xxxxx6vot8.eu-west-1.rds.amazonaws.com -U root -P '<PASSWORD>' -d master

---

2. Pindah ke msdb

USE msdb;
GO

---

3. Jalankan Prosedur RDS untuk Drop Database

Contoh nak delete JIRA_Linux_Copy:

EXEC msdb.dbo.rds_drop_database N'JIRA_Linux_Copy';
GO

Ulang untuk JIRA_Linux_Copy1 dan JIRA_Linux_Test:

EXEC msdb.dbo.rds_drop_database N'JIRA_Linux_Copy1';
GO
EXEC msdb.dbo.rds_drop_database N'JIRA_Linux_Test';
GO

---

4. Confirm Database Dah Hilang

SELECT name FROM sys.databases 
WHERE name IN (N'JIRA_Linux_Copy', N'JIRA_Linux_Copy1', N'JIRA_Linux_Test');
GO

Kalau result kosong → DB dah berjaya drop ✅

---

⚠️ Nota Penting

• Jangan guna DROP DATABASE biasa → RDS block sebab DB join Availability Group/Multi-AZ.
• rds_drop_database akan handle terminate connection, remove dari AG/mirroring, dan delete DB.
• Sekali drop → data hilang terus. Kalau perlukan backup, buat snapshot dulu di AWS Console.
• Storage RDS tak automatik mengecil bila DB delete. Kalau nak jimat kos, kena restore ke instance dengan storage lebih kecil.