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 AT lists.sourceforge DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|