02-24-2009 08:42 PM
I wish to backup a db2 database in 3 schedules with different retention periods
daily - 2 weeks
weekly - 2 months
monthly - infinite
I already have setup the three schedules with the "Automatic Full Backup" and the "Default-Application-Backup" with the "Application Backup" schedule type all in one policy. Have also configured the db2.conf file. However, the three backup schedules all have the same image retention periods when I browse them in the Images on media, all following the retention period for the "Default-Application-Backup" schedule.
How can I configure netbackup to set the correct retention periods on the images generated by each schedule. Any help on this will be greatly appreciated.
Solved! Go to Solution.
04-16-2009 08:55 AM
02-24-2009 09:35 PM
Aah! You've just met one of NetBackup's little caveats. When it comes to database backups and the "special" application backup schedule, the following applies... the user schedule that you create is the schedule that triggers the "default-application-backup". The "default-application-backup" is a kind of remoted execution application that will start a client process to do the database backup on the client. It is this special schedule that starts the process to run the .bch file specified in the files tab. When it comes to retentions, it's the "default-application-backup" schedule's retention that gets used.
Because of this, you will need to create a policy for each retention requirement and set the "default-application-backup"'s retention for each. Strangely, Exchange also has on of these special "application" schedules, but you can specify all your different retentions in one policy as the application schedule's retention does not get used.
In my scenario, I have to run Fulls, Diffs and Tx Log database backups for Daily, Weekly and Monthly. I also have up to 4 cluster groups with an SQL instance in each. Based on the above, I can have 4 SQL policies per instance running different .bch files which translates to 20 SQL policies to cover all my database servers (this includes stand-alone SQL servers).
Luckily, I created a GUI utilility that adds/removes all clients to and from NetBackup and also generates all the required .bch files depending on what choices the operator chooses.
Cheers
02-24-2009 09:43 PM
Thanks Dion.
I've actually tried to create a new policy with a different retention period on the "Default-Application-Backup", however, it still uses the one that is specified on the db.conf (this is actually a unix environment, sorry didn't mention it). I tried to add another entry on the db.conf but it still follows the first entry with the following
DATABASE smd
OBJECTTYPE DATABASE
POLICY SVXAPMEL210-BACKUP-02
SCHEDULE Default-Application-Backup
ENDOPER
DATABASE smd
OBJECTTYPE DATABASE
POLICY SVXAPMEL210-BACKUP_D-02
SCHEDULE Default-Application-Backup
ENDOPER
02-24-2009 09:57 PM
Sorry mate.
You did mention that it was a db2 database so I was aware. Don't have any of these on my side so just presumed that it followed the same methodology as SQL. Anyway, you can use the info if you have any SQL backups in the future.
Good luck
02-25-2009 01:55 AM
04-06-2009 03:49 AM
04-06-2009 04:53 AM
04-14-2009 04:20 PM
3sth3r, still no luck. will have to try scorpy_582's suggestion.
jbdb, were you able to find an answer to this? I have the same situation, one database but the customer wants different retention periods for daily / weekly backups
04-15-2009 12:06 AM
04-15-2009 03:35 AM
04-15-2009 05:10 AM
04-15-2009 08:16 AM
04-15-2009 11:09 PM
04-16-2009 03:06 AM
04-16-2009 08:55 AM
04-19-2009 09:11 PM
04-19-2009 11:30 PM
04-20-2009 06:07 AM
04-20-2009 06:28 AM