Long Term Retention is not supported : Not supported for database with Free edition.

[AlexPaskhin]

Is there an existing issue for this?

• I have searched the existing issues

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Terraform Version

1.1.7

AzureRM Provider Version

3.0.2

Affected Resource(s)/Data Source(s)

azurerm_mssql_database

Terraform Configuration Files

resource "azurerm_mssql_database" "mps_mssqldb" {
  name                 = "mps_db"
  server_id            = azurerm_mssql_server.mps_mssql.id
  collation            = "SQL_Latin1_General_CP1_CI_AS"
  sku_name             = var.sql_sku_name
  read_scale           = "false"
  zone_redundant       = "Local"
  storage_account_type = "Free"
}

Debug Output/Panic Output

│ Error: retrieving Long Term Retention Policies for Database: (Name "mps_db" / Server Name "dev-mps-mssql" / Resource Group "dev-rg-mps-spa-studio-wallsmedia"): sql.LongTermRetentionPoliciesClient#Get: Failure responding to request: StatusCode=400 -- Original Error: autorest/azure: Service returned an error. Status=400 Code="LongTermRetentionPolicyNotSupported" Message="Long Term Retention is not supported : Not supported for database with Free edition."
│
│   with azurerm_mssql_database.mps_mssqldb,
│   on mssql.tf line 47, in resource "azurerm_mssql_database" "mps_mssqldb":
│   47: resource "azurerm_mssql_database" "mps_mssqldb" {

Expected Behaviour

Pass

Actual Behaviour

Error: retrieving Long Term Retention Policies for Database:

Steps to Reproduce

terraform apply or plan

Important Factoids

No

References

None

[1mamute]

Also getting this error using 3.5.0. Can't create a free tier Azure SQL database because of it.

Edit: That's weird. Just noticed that the database was created even with the error in the terraform CLI. Now everytime I run a plan i get this error. Had to remove the SQL Database from the terraform state to keep building.

[RockyMM]

I observe the same behaviour.

Anyways, the 32 Megabytes database is not very useful. I am hoping more for support of the Free offer on the Serverless.

[github-actions]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.
If you have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.