I want to make a permanent backup in AZURE backup (that is, it is backed up only once and the backup remains in the vault and I can recover it for more than 5 years)

Question

The backup I want to make is a backup of a SQL database that I want to have in the cloud and if I need to recover it I can do it in a period of 5 years or more

Answer 1

Hi @Laura Fabiola Meza Gallegos

With Azure SQL Database, you can set a long-term backup retention policy (LTR) to automatically retain backups in separate Azure Blob storage containers for up to 10 years. You can then recover a database using these backups using the Azure portal, Azure CLI, or PowerShell.

When you enable a long-term backup retention policy, it may take up to 7 days for the first backup to become visible and available to restore.

Here are the reference documents- https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure?view=azuresql&tabs=portal

https://www.sqlshack.com/managing-retention-period-of-azure-sql-database-backup/

https://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-retention-overview?view=azuresql

Thank you!