We are implementing a five year data retention policy where we will be purging several tables in SQL Server 2019 of any data older than 5 years and one month from today. We will be deleting the data at the binning of each month for the prior month. The SQL table deletion is the easy part of this ask.

We also have backups that are sent to an Azure storage blob daily via RedGate Backup Pro. We store these 62 days and then they have an expiration policy in the blob storage that deletes them.

How do I purge the aged data out of the backups elegantly without downloading, restoring, deleting data, backing up, and uploading every backup, every month? Some of these backups are 2TB and a pain to move around…

Is there a tool that handles this or an alternative means of structuring our database or backups to make this more functional?