Enabling automatic backups can help prevent data loss for a MySQL server. Azure can create and save backups in either locally redundant or geo-redundant storage for greater resiliency, with geo-redundant storage providing the greatest availability. The maximum retention period for MySQL backup storage is 35 days and they are encrypted by default. For more information, see the Azure documentation.
References:
https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-backup-restore
Note: Updating this setting in either the Console or in Terraform will create a new deployment that may result in downtime.
In Azure Console -
In Terraform -
References:
https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-backup-restore
https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/mysql_flexible_server#geo_redundant_backup_enabled