Create a lifecycle management rule

The container where you store your backups will grow indefinitely over time, so its a good idea to add a lifecycle management rule on the backup container to purge old backups. This rule ensures that the container doesn't retain any backup data older than x number of days to keep your storage costs down.

To create this rule, you can run the following PowerShell script. You'll need to do this for every storage account where you are running backups.

https://github.com/SMSAgentSoftware/AzureTableBackup/blob/main/New-AzStorageLifecycleManagementRule.ps1

#####################################################################################################
## Creates a new lifecycle management policy for the table backups container used by this solution ##
#####################################################################################################

#! Run this for each storage account where you are backing up tables with this solution !#

# Set the parameters for the storage account
$azSubscription = "<MyAzureSubscription>"
$resourceGroupName = "<ResourceGroup>"
$storageAccountName = "<StorageAccount>"
$retentionPeriod = 180 # days
$backupContainerName = "tablebackups"
$ruleName = "Purge old table backups"

# Check for required modules
#Requires -Modules Az.Storage

# Authenticate with Azure AD
try 
{
    $null = Connect-AzAccount -Subscription $azSubscription -ErrorAction Stop
}
catch 
{
    throw "Authentication failure: $($_.Exception.Message)"    
}

# Create a new action object.
$action = Add-AzStorageAccountManagementPolicyAction -BaseBlobAction Delete -DaysAfterCreationGreaterThan $retentionPeriod

# Create a new filter object.
$filter = New-AzStorageAccountManagementPolicyFilter -PrefixMatch "$backupContainerName/" -BlobType blockBlob

# Create a new rule object.
$rule = New-AzStorageAccountManagementPolicyRule -Name $ruleName -Action $action -Filter $filter

# Create the policy.
Set-AzStorageAccountManagementPolicy -ResourceGroupName $resourceGroupName -StorageAccountName $storageAccountName -Rule $rule

Download the script and set the parameters at the top of the script:

• azSubscription (the name of the Azure subscription)

• resourceGroupName (the name of the resource group containing the storage account)

• storageAccountName (the name of the storage account containing the storage tables being backed up)

• retentionPeriod (the number of days you want to retain backup data for)

• backupContainername (the name of the container where the backups are stored)

• ruleName (the name of the rule you are creating)

After a successful execution of the script, you'll find the rule created in the storage account under Lifecycle management in the portal.

The rule uses a filter so that it applies only to the tablebackups container, and not any other containers, and will purge any backups older than the date you defined in the script.