Configurer le Backup retention pour SQL Database

configure-backup-retention.ps1

# déclaration des variables
$SubscriptionId = "bd......3c"
$Location = "canadacentral"

clear-host

# connexion à Azure et positionnement sur la bonne souscription
Connect-AzureRmAccount
Set-AzureRmContext -Subscription $SubscriptionId


$resourceGroup = "bd-dev-canadacentral-rg"
$serverName = "mysqlserverdev"
$dbName = "mydb"

# get the server
$server = Get-AzSqlServer -ServerName $serverName -ResourceGroupName $resourceGroup

# create LTR policy with WeeklyRetention = 12 weeks and MonthlyRetention = 6 months. YearlyRetention = 0 by default.
Set-AzSqlDatabaseBackupLongTermRetentionPolicy -ServerName $serverName -DatabaseName $dbName -ResourceGroupName $resourceGroup -WeeklyRetention P12W -MonthlyRetention P6M