+9Hello,
i would like to ask, if its possible to set retention period of each database different.
Based on Veeam helpcenter there is an option to set - “delete backups older than”, which will delete all backups of all databases due not native SQL backup supported.
Is there any option how to achieve that?
thank you
Best answer by Marcel.K
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.
+21As 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.
+2The 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).
+9MattM 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
+21If 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
+9the 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
+4Based on my experience, the best approach is to:
+21the 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.
+9I 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
