Smart retention works for days, weeks, and months. I would like to request that it also support specifying quarters and years, please. This is the policy I would like to be able to specify:
1 daily for last week (1-7 days from today backwards in time)
1 weekly for last month (2, 3, 4 weeks back)
1 monthly for last quarter (2, 3 months back)
1 quarterly for last year (2, 3, 4 quarters back, i.e. 6, 9, 12 months back)
1 annual all the way till the first backup (2-n years back)
I meant going backwards from the current date, and keeping the backups from “6, 9, and 12 months back”. “Quarterly” was thus the incorrect term. “3-monthly” would be more accurate.
Generically speaking, I would like the ability to specify that I keep only every n-th backup of each time interval (e.g. every 3rd monthly backup, every other weekly backup, etc.), and delete the others in that interval (delete monthly backup numbers 1, 2, 4, 5, 7, etc. going backwards in time).
The presumption is that the longer you haven’t needed something, the less likely it is that you will need it. Since we want to minimize the number of backups we retain while still providing coverage to fall back upon, the math makes sense. It permits for a more gradual staggering of deletions. 4 weeks in a month, 3 months in a quarter, etc. You’re not suddenly reducing your coverage by 90% as you would if you kept 1 monthly vs. 1 annual backup.
I didn’t come up with this idea myself. The IT department at the Fortune 1000 company I was working was using this retention policy for their SQL database backups. The title of the guy I automated this for was “Senior Storage Administrator”. So someone who knew enough about data backups for a $2B/year company to feed his family in the Bay Area thought this was the way to go.
They kept daily backups for 1 month, weekly backups for 3 months, monthly backups for 36 months, quarterly backups for 60 months, and yearly backups for 85 months.
I want to be able to do the same with my backups.
Regarding the existing featureset
Even after reading the syntax description, I do not understand the current featureset. For all I know, there is a way (“1Y:3M”??) to accomplish what I am seeking. But I wasn’t able to determine that from the 1 paragraph of documentation.