search

PGSSoft / terraform-provider-mssql

MS SQL Terraform provider
MIT License
17 stars 9 forks source link

mssql_database deletion fails when running on RDS instance with MultiAZ setup #127

Open Krad-dono opened 1 year ago

Krad-dono commented 1 year ago

So as in title - if you have created database using mssql_database resource on RDS SQL Server instance with MultiAZ setup terraform will fail to terminate/delete database.

Getting this error below:

module.database.mssql_database.rds_db["test"]: Destroying... [id=8]
╷
│ Error: Could not execute SQL
│ 
│ mssql: The database 'test' is currently joined to an availability
│ group.  Before you can drop the database, you need to remove it from the
│ availability group.
╵

To fix this mssql_database needs to run: EXECUTE msdb.dbo.rds_drop_database N'your-database-name' https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.DropMirrorDB.html