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
  ala...@caerllewys.net   ala...@metrocast.net   p...@co.ordinate.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to