[Bacula-users] Waiting for a volume already in the drive

2022-05-25 Thread William Muriithi
Hello, I have a problem that I don't seem to understand. Backups stopped because they needed a specific tape. However, the tape is already in the drive. I can't mount it, since its already in place. What would trigger bacula into this logic? Device status: Autochanger "SuperLoader3" with de

Re: [Bacula-users] query.sql

2022-05-25 Thread Phil Stracchino
On 5/25/22 13:23, SO Giuseppe - COMAE via Bacula-users wrote: SELECT count(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) AS Bytes,VolumeName FROM (SELECT DISTINCT Jobmedia.JobId, JobFiles, JobBytes, VolumeName       FROM Job,JobMedia,Media       WHERE JobMedia.JobId=Job.JobId       AND JobM

[Bacula-users] query.sql

2022-05-25 Thread SO Giuseppe - COMAE via Bacula-users
Hi I rewrote a sql command from the /opt/bacula/scripts/query.sql: # 11 :List total files/bytes by Volume SELECT count(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) AS Bytes,VolumeName FROM Job,JobMedia,Media WHERE JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId GROUP by Vo

Re: [Bacula-users] Different copy jobs and in which pool to be the target

2022-05-25 Thread egoitz--- via Bacula-users
It would be... ideal for me... if I could set for instance : In the full source pool : - Next Pool -> the monthly archive pool... In the Job that performs the monthly archival : - Next Pool -> the monthly archive pool... In the Job that performs the annual archival : - Next Pool ->

Re: [Bacula-users] Different copy jobs and in which pool to be the target

2022-05-25 Thread egoitz--- via Bacula-users
Hi Josh, Could the NextPool=full_archive_pool1 be set in the own job definition?. It would be simplier for me... because the real pool names, use as a seed for the pool name the catalog in which they are is that possible?. Best regards, El 2022-05-25 16:38, Josh Fisher escribió: > ATENC

Re: [Bacula-users] Different copy jobs and in which pool to be the target

2022-05-25 Thread Josh Fisher
On 5/25/22 08:12, egoitz--- via Bacula-users wrote: Good morning, I have question for whom I have not find a possible answer in the net or my kindle Books of Bacula... I wanted to have two different pools with different retention periods for full copied jobs. In that pools I would like to

[Bacula-users] Different copy jobs and in which pool to be the target

2022-05-25 Thread egoitz--- via Bacula-users
Good morning, I have question for whom I have not find a possible answer in the net or my kindle Books of Bacula... I wanted to have two different pools with different retention periods for full copied jobs. In that pools I would like to do one of the following options : - To copy a full job

Re: [Bacula-users] Question about differential backup

2022-05-25 Thread egoitz--- via Bacula-users
Hi Bill!! How are you :) :) :) Yes well.. the question was for knowing if I could recycle volumes of differential001 and 002 and I still could go to differential003 situation without 001 and 002. That was basically more than anything a question for knowing if I could recycle a diff

Re: [Bacula-users] Question about differential backup

2022-05-25 Thread egoitz--- via Bacula-users
Good morning!! Thank you so much!! Well in our case... was a retention related question I would like to know if I could recycle the differential001 and 002 in order to restore to differential003 situation. Basically to know if I could recycle those intermediate differentials... I see by