08-19-2010 07:35 AM
hello,
that maight be quiet simple.
I have a mssql online policy
and some schedules
anual - retention 5 years
mensal - retentinon 1 year
semana - retencion 3 months
diario - retention 2 weeks
so.. all of them R Automatic backups
there is one application schedulle for all of them, is that right?
and about the retention period should I put 5 years ??
Thanks
Solved! Go to Solution.
08-19-2010 12:20 PM
08-19-2010 10:36 AM
08-19-2010 12:20 PM
08-19-2010 12:26 PM
we create one police per server/kind of data
ex:
svjava-oracle-online
svjava-files
we create a schedule for each retention/time to run.
hourly/ weekly each one w/ a different retention.
is that ok??
08-19-2010 12:39 PM
08-19-2010 01:01 PM
08-19-2010 01:09 PM
1) a backup w/ application retentions 3 days and automatic retention 1 week... and see what really gona heppen w/ my data.
08-19-2010 01:16 PM
08-19-2010 01:27 PM
08-19-2010 01:34 PM
08-20-2010 07:48 AM
The implementation of SQL backup in NetBackup is a bit strange and sometimes a pain to work with but simply, the retention for the Application Backup schedule is used to determine how long the backup images will be kept (the schedule is not used by the server). The schedule for the Automatic Backup is used to determine when a backup runs, the frequency and the window (the retention does not get used).
As far as I can remember (it was quite a long time ago that I did the tests), the windows for both schedules are used. The windows for the Application Backup schedule determines when backups initiated from client machines can be run and the windows for the Automatic Backups determines when the policy can run.
Hope this helps
08-20-2010 09:56 AM
We are using the daily, weekly, montly and yearly policies to do sepereate retentions but will check the document to see they can be consolidated to one.
08-20-2010 12:27 PM
08-24-2010 12:52 PM
08-24-2010 06:41 PM
Schedule |
Monday | Tuesday | Wednesday | Thursday | Friday | Weekend | Retention |
---|---|---|---|---|---|---|---|
Automatic Schedule | Yes | Yes | Yes | Yes | Yes | Yes | n/a |
Daily Application Schedule | Open | Open | Open | Open | 1 Month | ||
Weekly Application Schedule | Open | 3 Months | |||||
4 Weekly Application Schedule | Open | 10 Years |