On 07/18/10 14:40, Joseph L. Casale wrote:
>> I have a fair number of failed jobs in my database, and I would like to 
>> know is it possible to purge all the bad backups, so that all the 
>> diskspace that has been taken up can be released?
> 
> from bconsole, `del jobid=#`.
> 
> If you have many, an sql query to look for JOB ID's with FAILED status piped
> out might be your ticket.

Be aware that this will not reduce the size of your disk volumes, unless
you're running a one-job-per-volume scheme.  If you're getting a lot of
job failures, and want to replicate only the good jobs, your best bet is
probably to migrate the good jobs to a new Pool and then replicate only
those.


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
         Renaissance Man, Unix ronin, Perl hacker, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users