I am looking to configure a Bacula installation to use a monthly full,
weekly differential, and daily incremental to a file pool. I will have
the required disk space to keep 3 months of these online for restores.
And will be keeping tapes offsite for a longer period of time. What I
would like to do though is make sure if we have to do a restore from
tape, that I don't end up needing to use 30 tapes for the restore. From
the reading I have done it appears that I will need to use a SQL Query
to determine the jobs to copy, finding the most recent full, the most
recent differential (if exists) since the full, and all incremental jobs
after the full or last differential.
Before I dive into the SQL table definitions and figure this all out, I
was wondering if I am missing something, that makes this a lot easier.
Or if anyone might already have a query already defined they would be
willing to share with me that I could use as a starting point.
--
Thanks,
Dean E. Weimer
http://www.dweimer.net/
------------------------------------------------------------------------------
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
