Why not run a manual prune command via cron and bconsole for night maint rather 
than hitting the DB directly?  

I ran into issues where my tapes weren't getting cycled as fast as I'd like, so 
basically did what you are talking about via bconsole/cron and it seems to have 
solved the problem.

-Dylan Vanderhoof
Sr. Network Engineer
Semaphore Corporation
http://www.semaphore.com

On Apr 4, 2011, at 2:51 PM, Dermot Beirne wrote:

> Hi,
> I'm using bacula 5.0.3 on ubuntu 9.04.
> 
> I want to know if its possible to find the sql query (or whatever is
> used) that bacula runs when it needs to prune and recycle a volume.
> 
> I would like this to run once a night, for each of my disk pools (say
> via a runscript), to prune them once their retention period has
> expired, rather than waiting until it can't create a new one.
> 
> I would then like to invoke the truncate command to recover the disk
> space occupied by the just pruned disk volumes.
> 
> I've been trying to write my own sql statement, but i'm struggling.
> 
> Thanks,
> Dermot.
> 
> ------------------------------------------------------------------------------
> Xperia(TM) PLAY
> It's a major breakthrough. An authentic gaming
> smartphone on the nation's most reliable network.
> And it wants your games.
> http://p.sf.net/sfu/verizon-sfdev
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


------------------------------------------------------------------------------
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users