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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
