SQL Database

1resource "azurerm_mssql_database" "main" {
2  name           = "sqldb-${var.project}-${var.environment}"
3  server_id      = azurerm_mssql_server.main.id
4  collation      = "SQL_Latin1_General_CP1_CI_AS"
5  max_size_gb    = 32
6  sku_name       = "GP_S_Gen5_2"
7  zone_redundant = true
8
9  short_term_retention_policy {
10    retention_days = 7
11  }
12
13  long_term_retention_policy {
14    weekly_retention  = "P1W"
15    monthly_retention = "P1M"
16    yearly_retention  = "P1Y"
17    week_of_year      = 1
18  }
19
20  tags = var.tags
21}