Support for [Point In Time Restore of a deleted Azure Sql Database]

[jayat66]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Description

Currently the resource azurerm_ssql_database offers 2 options

Restore - works with the option 'restore_dropped_database_id'
PointInTimeRestore works with the option 'creation_source_database_id'

However,
Restore does not work with restore_point_in_time.
Similarly PointInTimeRestore does not work with restore_dropped_database_id

Which means, We cannot restore to a desirable time for a dropped database. This can be done through GUI but not Terraform. Need ability to perform restores of a deleted database to a desirable time.

New or Affected Resource(s)

• azurerm_mssql_database

Potential Terraform Configuration

# Copy-paste your Terraform configurations here - for large Terraform configs,
# please use a service like Dropbox and share a link to the ZIP file. For
# security, you can also encrypt the files using our GPG public key.

References

• #0000

[jayat66]

Currently the resource azurerm_ssql_database offers 2 options

1. Restore - works with the option 'restore_dropped_database_id'
2. PointInTimeRestore works with the option 'creation_source_database_id'

Restore does not work with restore_point_in_time.
Similarly PointInTimeRestore does not work with restore_dropped_database_id

Which means, We cannot restore to a desirable time for a dropped database. This can be done through GUI but not Terraform. Need ability to perform restores of a deleted database to a desirable time.