cancel
Showing results for 
Search instead for 
Did you mean: 

Duplication Backup Set to Tape duplicate all backup set

paguti20
Level 4
Partner Accredited

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?

2 REPLIES 2

Vasilis_Peppas
Level 4
Partner Accredited

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
Level 4
Partner Accredited

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