Support for SQL managed instance backup storage redundancy

[tanvp112]

By default, SQL Managed Instance created by azurerm_sql_managed_instance store data in geo-redundant storage blobs that are replicated to a paired region.

This is not a configuration issue on the portal or CLI. Currently there is no option to use ZRS as the backup storage redundancy for SQLMI created using azurerm_sql_managed_instance module. The default geo-redundant cannot be used because of data locality requirement - render the azurerm_sql_managed_instance module being useless in this case.

[github-actions]

This functionality has been released in v2.89.0 of the Terraform Provider. Please see the Terraform documentation on provider versioning or reach out if you need any assistance upgrading.

For further feature requests or bug reports with this functionality, please create a new GitHub issue following the template. Thank you!

[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.