module.rds_sql_server.aws_db_option_group.this[0]: Creating... ╷ │ Error: Error modifying DB Option Group: InvalidParameterCombination: SQLSERVER_BACKUP_RESTORE option doesn't support versioning. Don't specify a version number. │ status code: 400, request id: 99a6ff55-8b07-486e-bfda-2884c25248df │ │ with module.rds_sql_server.aws_db_option_group.this[0], │ on ../main.tf line 302, in resource "aws_db_option_group" "this": │ 302: resource "aws_db_option_group" "this" { │
The error message we were encountering indicates that the AWS RDS SQL Server option group configuration you are trying to create includes an option called "SQLSERVER_BACKUP_RESTORE," which doesn't support versioning. Specifically, it's asking you not to specify a version number for this option. However, in your Terraform configuration, you have defined a version for this option:
version = "1.0" // TODO - make variable
To resolve this issue, you should remove the version attribute for the "SQLSERVER_BACKUP_RESTORE" option when it is not supported. You can use a conditional expression to include the version attribute only when the option is "S3_INTEGRATION" and not when it's "SQLSERVER_BACKUP_RESTORE."
module.rds_sql_server.aws_db_option_group.this[0]: Creating... ╷ │ Error: Error modifying DB Option Group: InvalidParameterCombination: SQLSERVER_BACKUP_RESTORE option doesn't support versioning. Don't specify a version number. │ status code: 400, request id: 99a6ff55-8b07-486e-bfda-2884c25248df │ │ with module.rds_sql_server.aws_db_option_group.this[0], │ on ../main.tf line 302, in resource "aws_db_option_group" "this": │ 302: resource "aws_db_option_group" "this" { │The error message we were encountering indicates that the AWS RDS SQL Server option group configuration you are trying to create includes an option called "SQLSERVER_BACKUP_RESTORE," which doesn't support versioning. Specifically, it's asking you not to specify a version number for this option. However, in your Terraform configuration, you have defined a version for this option:
version = "1.0" // TODO - make variableTo resolve this issue, you should remove the version attribute for the "SQLSERVER_BACKUP_RESTORE" option when it is not supported. You can use a conditional expression to include the version attribute only when the option is "S3_INTEGRATION" and not when it's "SQLSERVER_BACKUP_RESTORE."