Alexander (Sasha) Nosov, the Principal Program Manager of Azure SQL Database, has taken to an official Microsoft Azure blog to announce that Azure SQL Database now supports up to 10 years of Backup Retention. The support means that you can extend built-in retention period from 35 days to up to 10 years, or retain data for an extended period if your application has compliance requirements.
According to Alexander, supporting data requirements is much simpler, and “SQL Database automatically creates a full backup every week for each of your databases.”
Additionally, after adding an LTR policy to a database using Azure Portal or API,” weekly backups will be automatically copied to your own Azure Backup Service Vault.” Databases encrypted with TDE are also not an issue, and will be “automatically encrypted at rest,” and other backups will automatically “be deleted by the Services Vault based on time stops.”
To learn more about Azure SQL Database, you can check out this official web page. Once you’ve checked it out, let us know your impressions by dropping us a comment in the section below!