On 05/28/13 16:10, dweimer wrote: > 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.
No. Bacula will take care of that for you. You tell it what you want to restore from when to where, and it will search the catalog and tell you what media you will need to perform the restore. Also remember that you always have the ability at any time to create a "virtual full" job from the most recent Full, Differential, and applicable incrementals. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater It's not the years, it's the mileage. ------------------------------------------------------------------------------ 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