Configure long-term backup retention

To configure long-term backup retention for your Azure SQL Solutions, you can use the Azure Portal, PowerShell, or Azure CLI. This article will guide you through the process using all three methods.

Using Azure Portal:

1. Sign in to the Azure Portal and navigate to your Azure SQL Solution resource.
2. In the left-hand menu, select “Backup and restore.”
3. Under “Long-term backup retention,” click on the “Configure” button.
4. In the “Retention period” section, specify the number of days you want to retain backups. You can choose a value between 7 and 10,080 days.
5. In the “Weekly retention” section, choose the day of the week that you want the system to take a full backup. You can enable up to four weekly backups.
6. In the “Monthly retention” section, choose the week of the month and the day of the week when you want the system to take a full backup. You can enable up to 12 monthly backups.
7. Click “Apply” to save your changes.

Using PowerShell:

Make sure you have the Azure PowerShell module installed and imported.

Connect-AzAccount

Select the Azure subscription containing your Azure SQL Solution:

Select-AzSubscription -SubscriptionName "YourSubscriptionName"

Set the context to your Azure SQL Solution:

Set-AzSqlDatabaseLongTermRetentionBackup -ResourceGroupName "YourResourceGroup" -ServerName "YourServerName" -DatabaseName "YourDatabaseName" -WeeklyRetention P7W -MonthlyRetention P12M -YearlyRetention P10Y

Note: Adjust the resource group, server name, database name, weekly retention (P7W), monthly retention (P12M), and yearly retention (P10Y) according to your requirements.

Using Azure CLI:

Ensure you have the Azure CLI installed and configured.

az login

Set the active subscription containing your Azure SQL Solution:

az account set --subscription "YourSubscriptionName"

Configure the long-term backup retention for your Azure SQL Solution using the following command:

az sql db ltr-policy set --name "YourDatabaseName" --server "YourServerName" --resource-group "YourResourceGroup" --weekly-retention P7W --monthly-retention P12M --yearly-retention P10Y

Note: Replace “YourDatabaseName,” “YourServerName,” “YourResourceGroup,” weekly retention (P7W), monthly retention (P12M), and yearly retention (P10Y) with your own values based on your specific configuration.

By following the steps using the Azure Portal, PowerShell, or Azure CLI, you can easily configure long-term backup retention for your Azure SQL Solution. This will ensure that you have reliable and secure backups of your data for extended periods, meeting your specific retention requirements.