Hi list.

I have suffered quite alot from failed jobs, due to one reason or
another over the last couple of years in my bacula installation. I
suspect that I have tapes sitting on the shelf with only failed jobs
on them. Since they never will be  used for restores I might as well
just cycle them and get them reused.

I'm not too strong in examining the bacula catalog. But does this 
approach seem sane?

select JobStatus,VolumeName,count(distinct(Job.JobId)) from 
Job,JobMedia, Media where Job.JobId = JobMedia.JobId and 
JobMedia.MediaId = Media.MediaId group by VolumeName,JobStatus order by 
VolumeName;
+-----------+------------+----------------------------+
| JobStatus | VolumeName | count(distinct(Job.JobId)) |
+-----------+------------+----------------------------+
| T         | 000696L3   |                          1 |
| T         | 000697L3   |                          2 |
| T         | 000699L3   |                          4 |
| f         | 000700L3   |                          1 |
| T         | 000702L3   |                         12 |
| T         | 000703L3   |                          2 |
| f         | 000703L3   |                          1 |
| T         | 000704L3   |                          1 |
| f         | 000705L3   |                          1 |
| T         | 000706L3   |                          4 |
| T         | 000707L3   |                        105 |
| T         | 000708L3   |                          3 |
| T         | 000709L3   |                         16 |


I would now conclude that I can recycle 000700L3 since it only has 1
failed jobs on the complete tape. 0000703L3 cannot since it has 2
successfull jobs and one failed... and so on?

Is this a viable approach or am I overlooking something?

Thanks Jesper
-- 
Jesper

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users