cancel
Showing results for 
Search instead for 
Did you mean: 

BE 12.5 and SQL backup schedule

tyj
Level 3
I would like to set up a DB backup schedule that includes 1 daily full backup, a differential backup that runs every three hours, and a transaction log backup that runs every hour.    I can see that I can set up tto have backups run at intervals which would allow me to do this schedule, however I do not want the backup to run into each other.  In otherwords, on every third hour when the differential backup runs, I do not want the log backup to run also.  And I do not want either of these to try and run at the same time the full backup kicks off.  Is there a way to specify each hour what backup is supposed to run without having to create a separate job for each hour?
1 REPLY 1

Hemant_Jain
Level 6
Employee Accredited Certified
You may check the policy rules for this implementation. You will create a policy with three templates, full, differential and incremental. Then, create rules to specifiy what action to be taken if start time of jobs conflict. This should work for you to some extent. Once you have created the policy, you can attach it to common selection list, and that would generate three backup jobs. So, using rules, you can give preference to full over other templates and differential over log templates. Here are some documents for your reference, with setting up policies:
http://support.veritas.com/docs/299219
http://support.veritas.com/docs/299230

Please mark it a solution, if this is useful.
Thanks