As best I understand the plugin there is no option for this current. I would suggest checking the Forums and putting in a suggestion there - https://forums.veeam.com
Not sure what is planned in v13.
The retention configured in a SQL-plugin job (as shown on the helpcenter page you referenced) applies only to the databases that are protected by this job. You can create multiple jobs, each having its individual retention.
Thus, you CAN set different retentions for each database you’re protecting. You just need to create a separate job for each retention you need (and add the corresponding databases to this job only).
MattM we have been create multiple job, but in the reference is link to delete all backups after x days, not retention period as such, even is provided by different job
If you have the delete after X days set then it should delete backups after that many days but keep in mind it keeps 7 days by default -
In the Delete backups older than <N> days field, specify the number of days for which you want to keep backups in the backup repository. By default, Veeam Plug-in keeps backup files for 7 days
the requirement from customer is to have different retention periods
like for DB A, B, C 14 days, for DB D,E,F 1 months
on otp of that for DB A,D monthly backup with 1 year retention
so we have 3 jobs in sql studio
but if job for A,B,C will run, it will delete backups for D,E,F and yearly backups as well, because job for A,B,C DBs has “delete older than 14 days”
So issue is that it should skip deleting backups for D,E,F and yearly backups, but is not the case
Based on my experience, the best approach is to:
- Create separate backup jobs for each database or group of databases with similar retention needs.
- Use SQL Agent Jobs to schedule backups independently if needed.
- Manage retention through the repository settings and job configuration in Veeam Backup & Replication.
the requirement from customer is to have different retention periods
like for DB A, B, C 14 days, for DB D,E,F 1 months
on otp of that for DB A,D monthly backup with 1 year retention
so we have 3 jobs in sql studio
but if job for A,B,C will run, it will delete backups for D,E,F and yearly backups as well, because job for A,B,C DBs has “delete older than 14 days”
So issue is that it should skip deleting backups for D,E,F and yearly backups, but is not the case
Then you need to separate all the databases to allow proper retention. There is no way around it.
I have tested that via different agent jobs as you suggest in this topic, but is always were backups deleted by shortest retention
I have opened case and statement is:
· GFS – is currently not available for the MSSQL Plugin
· Different retention periods for different databases on the same server | The retention period is implemented based on the shortest retention of all the jobs configured on the machine (regardless of the databases included).
So currently is not possible GFS and different retentions for different databases.
I have created feature request for that on R&D.