azurerm_mssql_virtual_machine: support auto_backup

[manicminer]

Replaces #10107

Support configuring auto backup for azurerm_mssql_virtual_machine

• Enabling/disabling is determined by presence of auto_backup block
• WaitForState func is needed as auto backup settings take awhile to take effect, whether adding/removing or updating

[katbyte]

Have a couple questions about schema names but otherwise is looking good

[manicminer]

@katbyte I've dropped the toggle attribute for automatic/manual backup scheduling, and used the presence of the manual_schedule block instead, which has simplified the custom diff function. Also, due to a service error, auto_backup cannot be removed without causing the resource to fail.

Still pending test results due to the memory issue on the CI server, but it's passing locally for me with these test configs.

[manicminer]

Test results

[katbyte]

Thanks @manicminer - LGTM now!

[ghost]

This has been released in version 2.47.0 of the provider. Please see the Terraform documentation on provider versioning or reach out if you need any assistance upgrading. As an example:

provider "azurerm" {
    version = "~> 2.47.0"
}
# ... other configuration ...

[ghost]

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 feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. If you feel I made an error 🤖 🙉 , please reach out to my human friends 👉 hashibot-feedback@hashicorp.com. Thanks!