Immutable Backups In my case, the SQL backup maintenance plan is as follows:
Full - Weekly
Differential - Daily
T-Log - Hourly
Each goes into a folder like Backups\Full\DBName, Backups\Diff\DBName, Backups\Log\DBName. Each backup goes into a unique file with a timestamp in the name.
Once per week, just before the full backup, a job runs to delete all the previous week's backups off of disk.
By such a time, the assumption is that all backups are stored on Amazon, in the case of Full/Differential the last ten years, and in the case of t-log the last 90 days.
Several times per week we need to restore a full, diff, and log from Amazon to reproduce reported problems.
With respect to the GFS settings, what would I set for retention to get closest to my goal, assumption I do weekly 'full' and hourly 'incremental' on the MSP360 side?