[Bacula-users] Looking in catalog for "reusable tapes".

[Jesper K. <je...@kr...>]

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