Netbackup backups based on last modified date

[yobole]

We have a scenario where we replicate backup data between two sites using NAS storage at both ends keeping 30 days’ worth of SQL dumps. We will however only like to back up the very last data once a month to tape using Netbackup. Can Netbackup performs this using just the last modified date.. I.e. backup files only create with 24hrs

[Marianne · Accepted solution]

NetBackup cannot do that.

NBU backup policy will either do Full or Incremental of everything specified in Backup Selection.

So, if you have a folder name in Backup Selection, a FULL will backup everything in the folder.
Incremental backup will backup everything modified since the last full backup.

In your scenario, you will have to script a user backup that will find files modified in last 24 hours and use as input to bpbackup.

[Nicolai]

Or use regular expression as part of the backup selection

e.g

/data/vol/dump*.sql.tagged_for_monthly_backup

/data/vol/dump*monthly*.sql

Hope you get the picture ...

Naming of the SQL dump files of cause need adjustment for this new requirement.

[Yasuhisa_Ishika]

Or,

Option 1: Run daily differential backup using calendar based schedule. Set short retention for regular daily backups, and set longer retention for monthly backup.

Option 2: Run daily differential backup. Its file selection is dummy path which must exist but empty. Before monthly backup, add actual target path into file selection, and remove it after monthly backup. It can be done by shell or batch scripting.