Setting the max database size for azure sql

62 views
Skip to first unread message

cgcamp...@gmail.com

unread,
Sep 16, 2020, 9:28:37 AM9/16/20
to Terraform
I am in the process of trying to restore a database in azure sql but the default size is for max size is not big enough. i have tried setting the size but it complains with the below error message. Has anyone been successful in setting the max size? I have tried diff sizes by doing 1000 to 50000000 with and with out qoutes. i have changed the editions but to no luck on any of them.

error message:
"The edition 'Standard' does not support the database data max size '50000000000'.","target":null}]
////////////////////////////////
terraform code
////////////////////////////////
resource "azurerm_sql_database" "azuresql" {
  name                = var.database_name_1
  location            = data.azurerm_resource_group.ResourceGroup.location
  server_name         = azurerm_sql_server.azuresql.name
  create_mode         = "Default"
  edition             = "Standard"
  requested_service_objective_name = "S12"
  max_size_bytes      = 50000000000
  import {
    storage_uri                  = "URL_to_bacpac_file"
    storage_key                  = data.azurerm_storage_account.storage.primary_access_key
    storage_key_type             = "StorageAccessKey"
    administrator_login          = azurerm_sql_server.azuresql.administrator_login
    administrator_login_password = azurerm_sql_server.azuresql.administrator_login_password
    authentication_type          = "SQL"

  }


Reply all
Reply to author
Forward
0 new messages