Hello,

I'm still looking for a way to predict which tapes bacula will try to recycle,
so that I can pre-load our autochanger instead of having all backups halt with
the "intervention needed" message. For example, I've got ~50 volumes in the 
"incremental" pool that are "full", but I don't know which ones to load into the
changer to be recycled.

I understand that there's currently no way to run the recycle algorithm
manually.

I was considering the querying the database to produce a list of full volumes,
reverse sorted by the age of the newest backup per volume. This list would tell
me which are the "oldest" tapes (where the age is given by the newest backup per
volume, not the first use of a volume).

Does this seem like a reasonable approximation of the order in which bacula
would recycle tapes (assuming that they are all in the changer, and assuming
that all jobs per volume have the same retention period)?

If so, I'd really appreciate some help with the SQL query to extract this data.


Thanks,

Mark
 
----
Mark Bergman                      [EMAIL PROTECTED]
System Administrator
Section of Biomedical Image Analysis             215-662-7310
Department of Radiology,           University of Pennsylvania

http://pgpkeys.pca.dfn.de:11371/pks/lookup?search=mark.bergman%40.uphs.upenn.edu



The information contained in this e-mail message is intended only for the 
personal and confidential use of the recipient(s) named above. If the reader of 
this message is not the intended recipient or an agent responsible for 
delivering it to the intended recipient, you are hereby notified that you have 
received this document in error and that any review, dissemination, 
distribution, or copying of this message is strictly prohibited. If you have 
received this communication in error, please notify us immediately by e-mail, 
and delete the original message.

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to