Terraform issue while updating aws rds sql server

[Rajinder Singh]

I had provisioned RDS SQL Server express edition.

I wanted to update the edition of SQL Server to standard edition.

I updated my terraform config file and ran terraform apply.

When terraform ran it first deleted the existing database server.

It tried creating the new server.

It failed because SQL Server standard edition requires 200 GB minimum disk space and express edition had 100 GB.

I updated my tfvars file to set the allocated value to 200.

However I still keep on getting errors telling me that I am allocating 100 GB but I should be allocated between 200 to 1024 GB.

When I run terrafrom apply it shows that it will allocate 200 GB but fails with a message that I am allocated 100 GB.

I have looked at the tfstate file and it does not have any reference to the RDS instance I am trying to create.

So I cannot figure out where it is getting the value of 100 GB from.

Let me know if you have any suggestions. I need to create the database soon and I would have to create it manually if I cannot get past this issue.

Thanks

[Rajinder Singh]

I did create a snapshot of the old SQL database.

So the new database is trying to restore from the previous snapshot. The previous snapshot is 100 GB in size. Perhaps this is where I am getting errors.

I will try to create the new instance manually next.

[Rajinder Singh]

AWS RDS SQL Server is unable to restore a SQL Server Express edition snapshot to SQL Server Standard edition if the disk size does not meet the minimum size requirements.

So this was not Terraform issue.

[Clint Shryock]

Thank you for reporting those findings. I hope this means you got things sorted out?

Regards,

Clint

--
This mailing list is governed under the HashiCorp Community Guidelines - https://www.hashicorp.com/community-guidelines.html. Behavior in violation of those guidelines may result in your removal from this mailing list.
 
GitHub Issues: https://github.com/hashicorp/terraform/issues
IRC: #terraform-tool on Freenode
---
You received this message because you are subscribed to the Google Groups "Terraform" group.
To unsubscribe from this group and stop receiving emails from it, send an email to terraform-too...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/terraform-tool/83b0a111-13ec-4c6e-9f50-4ea31e63dfbe%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Clint

[Rajinder Singh]

Clint,

Yes I was able to work through this issue.

I created the database deleted by Terraform from the snapshot.

Yes I created a new instance of SQL Server using Terraform.

I migrated my databases from the old database server to the new database server.

Raj