Video Screencast Help

Duplication Backup Set to Tape duplicate all backup set

Created: 06 Jun 2013 | 2 comments
paguti20's picture

We need duplicate backup only last week backup set:

  • First duplication      -  Alls backup set week 1
  • Second duplication  -  Alls backup set week 2
  • Third duplication      -  Alls backup set week 3
  • Fourth duplication    -  Alls backup set week 4

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:

  • First duplication      -  Alls backup set week 1
  • Second duplication  -  Alls backup set week 1 + Alls backup set week 2
  • Third duplication      -  Alls backup set week 1 + Alls backup set week 2 + Alls backup set week 3
  • Fourth duplication    -  Alls backup set week 1 + Alls backup set week 2+ Alls backup set week 3 + Alls backup set week 4

Any help about we need?

Operating Systems:

Comments 2 CommentsJump to latest comment

Vasilis Peppas's picture

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 

SONGYOD.KH's picture

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