08-04-2014 09:36 AM
I have a MSSQL policy configured with three Automatic schedules and three Application schedules.
Daily Schedule:
Automatic schedule = 7pm to 8am.
Application schedule = 7pm to 8am with a retention of 1 week
Weekly Schedule:
Automatic schedule = 7pm Friday to 8am Monday every week with exception of the last Friday of each month.
Application schedule = 7pm Friday to 8am Monday every week with exception of the last Friday of each month with retention of 1 month.
Monthly Schedule:
Automatic schedule = 7pm Friday to 8am Monday on the last Friday of each month.
Application schedule = 7pm Friday to 8am Monday on the last Friday of each month with retention of 3 months.
They appear in the following order in the policy:
Daily
Monthly
Weekly
The daily runs OK and retains data for the intended 1 week.
However as the weekly and monthly application schedules are open at the same time is seems to always pick the monthly schedule (the first that appears in the list). So when the weekly backup runs it is retained for 3 months instead of the intended 1 month.
I have searched and searched and cannot find any hints as to how this should be configured so that I can have all three schedules in the same policy. Is this possible? If so how should it be confgured?
Thanks in advance for any help.
Solved! Go to Solution.
08-04-2014 11:56 AM
Have a look at this TN:
http://www.symantec.com/docs/TECH90544
DOCUMENTATION: How to create a single MS-SQL-Server NetBackup policy which contains multiple schedules with different retention levels
08-04-2014 09:58 AM
In our setup there are different policies for sql for different retention
08-04-2014 10:00 AM
Also retention for automatic and application schedule should be same which is not possibe in database polices
08-04-2014 10:06 AM
Weekly Schedule:
Automatic schedule = 7pm Friday to 8am Monday every week with exception of the last Friday of each month.
Automatic schedule = 7pm Friday to 8am Monday every week with exception of the last Friday of each month with retention of 1 month.
Monthly Schedule:
Automatic schedule = 7pm Friday to 8am Monday on the last Friday of each month.
Automatic schedule = 7pm Friday to 8am Monday every week with exception of the last Friday of each month with retention of 3 months.
see the bold highlighted above... does it typo.. or is that how its configured?
08-04-2014 11:19 AM
Yes there were a few typos there. Now corrected. Apologies.
08-04-2014 11:26 AM
Sorry I'm not sure what you mean by this. The retention is the same for Auto and App schedules but I didn't thing the Auto was taken into account. Only the App sched is used.
08-04-2014 11:32 AM
So is there no way to have all schedules in the same policy. Seems a bit messy to have multiple policies for different retentions. Most other policy types (windows, VMWare, etc) seem to be able to handle this OK.
If Application schedules had the option to set a Calendar schedule type then this would be possible, yes? So why would Application schedules not have this option? Is it just another NB "feature" or is there an valid reason for not having this option on App schedules?
08-04-2014 11:56 AM
Have a look at this TN:
http://www.symantec.com/docs/TECH90544
DOCUMENTATION: How to create a single MS-SQL-Server NetBackup policy which contains multiple schedules with different retention levels
08-04-2014 09:13 PM
yep..
extract from above T/N in Marianne comment.
"Please note that it is very important the two "Backup Policy" schedules do not overlap. If they do overlap, unpredictable results can occur, and backups could fail to take place or could expire prematurely."
so edjust the schedule times and see how it works..
08-06-2014 04:35 AM
Thanks for your help everyone.
We have set up a second policy for Monthly backups with 3 month retentions.
Still seems a little messy to me but if that is the way it needs to be then thats fine.
Thanks again.