06-06-2013 07:48 AM
We need duplicate backup only last week backup set:
My job is:
First Stage:
- Full Backup SQL : 8:00 am. and 8:00 pm. (each 12 hours) , to disk , retention for 4 week
- Backups SQL Logs: 12:00 am., 6:00 am., 12:00 pm., 6:00 pm.- (each 6 hours) , to disk, retention for 4 week
Segundo Stage:
- Duplicate to Tape : Saturday 10:00 (each week) , source: all backup set
But this duplicate in tape:
Any help about we need?
06-06-2013 08:24 AM
Hi
I think the only easy way is to duplicate only the most recent full backup. Set the schedule for the last saturday of the month and in the selection put in most recent full backup . Since you have frequent full backups it shouldn't be a problem.
BR
06-27-2013 08:43 PM
You have to separate duplicate stage per backup job.
Add 2 Backup schedules:
- Full SQL :schedule as 12-hourly
- SQL Log :schedule as 6-hourly
Add 2 Duplicate stages:
- Duplicate Full : select only Full SQL as source and schedule as weekly
- Duplicate Log : select only SQL Log as source and schedule as weekly