I believe we have a significant number of tapes that bacula thinks are "full" but which no longer have jobs. These tapes were used normally and became full. Later we decommissioned the machines that were backed up to those tapes and pruned & purged the bacula jobs that referenced the decommissioned machines. The job & file records no longer exist in the database, but bacula still considers the tape to be "full", with a long expiration period (as set by the pool for full backups).
Some of the tapes may also "store" failed backups, so the tape may have jobs, but the sum of the files on tape is zero bytes. We have no need to recover data from those tapes and want to re-use the media. Can anyone recommend a MySQL query to list all volumes that have zero jobs or zero files or jobs where the files sum to zero bytes? Thanks, Mark ------------------------------------------------------------------------------ LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely access PCs and mobile devices and provide instant support Improve your efficiency, and focus on delivering more value-add services Discover what IT Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
