Tonight I was thinking how I want to structure my backups. I'm
presently backing up to disk and I'm about to running Copy Jobs from
there to tape.
Then I started thinking: if I keep quarterly FULL backups (a full backup
done every three months), I would have more space to keep backups
longer. Let's assume those quarterly backups are kept for 10 years,
which will require a new Pool with 'Volume Retention = 10 years'.
But how best to achieve these quarterly backups? My initial thoughts
were along the lines of the classic schedule:
Run = Level=Full 1st sun at 8:15
Run = Differential 2nd-5th sun at 8:15
Run = Incremental mon-sat at 8:15
but adjusted slightly for every three months:
Run = Level=Full jan apr jul oct 1st sun at 8:15
This this quickly becomes complicated. For starters, it requires a
different Job, a different schedule.
Later I thought about Copy Job. Why not just use Copy Job to achieve
the same thing? This allows the schedule to stay simple and clear. A
simple way to achieve this would be a new Copy Job using the above
mentioned schedule (but run a few hours later). The Copy Job would contain:
Selection Type = SQLQuery
Selection Pattern =
SELECT jobid
FROM job
WHERE endtime > current_timestamp - interval '3 days'
AND level = 'F'
AND type = 'B'
AND Job.JobStatus IN ('T','W')
AND Job.jobBytes > 0;
This should pickup all full jobs run in the past 3 days. Why three days?
Just a bit of flexibility and wiggle room. The query will also need
to be refined for Pool name.
Ideas? Comments?
I thought this was a great idea, until I realized that Copy Job depends
upon the 'Next Pool' directive in the source Pool. This prevents a
given Job from being copied to more than one Pool. Ouch, bummer.
That's something I'd really like to do. Is it possible?
--
Dan Langille - http://langille.org
------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
