Multiple Schedules in SQL backup policies

[Steve_Law]

Hi,

We're using NB7.5 writing to Data Domain disk storage and to tape.

We run daily, weekly and monthly backups on live SQL databases. We have a policy for a specific backups, and following the support doc here - https://support.symantec.com/en_US/article.TECH90544.html - I can create schedules with start times so if the job runs on a weekday it writes to Data Domain storage (6 weeks retention) or at the weekend it runs the weekly SLP (writes to Data Domain with 6wks retention then also replicates to a tape with 1 year retention).

But what about our month end backups? They also happen at weekends. Given the current options there is no way to differentiate whether the backup is a weekly or monthly backup, so no way to set the monthly backup to the standard 10 year retention on tape. 

Is there a way to specify an application backup schedule when running the job at the command line? (All our jobs are run like that via a 3rd party scheduler). 

If not I'll have to create a dedciated month end policy.

[Yasuhisa_Ishika · Accepted solution]

You can initiate SQL backups using "bpbackex -f batch_file" on the client. But creating monthly policy is simple way to sort this out.

[Varunthilak_B]

1. Create Monthly schedule within existing policy and select your STU/STUG/SLP (whatever you want) with over ride option, Also adjust your backup window for weekly/monthly schedules.

2. As per above suggestion, Creating monthly policy can also fix this issue.