Hi James, perhaps this SQL statement is able to help you a little bit (check it in bconsole->SQL query please): select jobid from (select name,jobtdate,count(name) as co from Job where level='F' and jobstatus='T' and type='B' group by name) as RS where co=1 and (UNIX_TIMESTAMP(now())-jobtdate)>21600000;
You can create an additional pool for your roadwarrior stuff an run every day a migration or copy job. The "Selection Type" should be "SQLQuery" and take the sql statement in the "Selction Pattern" directive. Also you should adjust the integer value at the end of sql statement. The value stands for the seconds to the point in time your full backups should be considered by the statement. This value should be near by the retention period, but some days/weeks smaller. Your new daily running "house keeping" job then will look for all SUCCESSFULLY executed jobs with only one full backup left. All these jobids then will be migrated/copied to your destination pool. Your destination pool should get a much higher retention then your primary pool, so the jobs will be safe there. All this is currently not tested by us, so you probably have to take some adaptions to this. Please keep me informed, if you can use this and how all fit together exactly. Regards Michael Am 26.03.2011 03:33, schrieb James Harper: >> Not that I know of >> >>> If I got it right then the file- and job >>> retention is overruled by the volume retention, so I don't see a >>> solution for this problem... >> Consider this... >> >> Keep File and Job Retention at 3 years. >> >> Create a new pool with retention 3 years, call it LONGTERM. >> >> Once a day, run a copy job. Look for Full backups that are more than >> four weeks old. Copy such jobs to the LONGTERM pool. >> >> Then if you wish, have another script which if it sees a newer full in >> the regular pool, it purges the LONGTERM pool. >> > You could also code up some SQL to push the retention date out to > infinity on the most recent full backup, and reset the retention date on > volumes that not the most recent full backup. Just set it to run on job > completion. > > James > > ------------------------------------------------------------------------------ > Enable your software for Intel(R) Active Management Technology to meet the > growing manageability and security demands of your customers. Businesses > are taking advantage of Intel(R) vPro (TM) technology - will your software > be a part of the solution? Download the Intel(R) Manageability Checker > today! http://p.sf.net/sfu/intel-dev2devmar > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users ------------------------------------------------------------------------------ Create and publish websites with WebMatrix Use the most popular FREE web apps or write code yourself; WebMatrix provides all the features you need to develop and publish your website. http://p.sf.net/sfu/ms-webmatrix-sf _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
