Hi again, now, i tried some different approaches. But can't get to a solution :(.
1) I used my sql selection query above -> Bareos select the jobs, but don't copy it. It says there is already a copy for the job. That's right ... beacuse the job i try to copy is marked as Archive :( 2) the next Idea was, to define a second VirtualLongTerm job which uses my "ExternPool". But this also failed, because the target pool is selected from the "Next Pool" parameter which is set in AI-Consolidated. And it is not allowed to define multiple Next Pools in a Pool Configuration. Now, I can't find any solution how to get a offsite LongTerm Copy :/. I'm also opened for a compelte different solutions :) if there is one. In short: 1) I want to use the Always Incremental backups 2) I need a LongTerm Pool for VirtualFull Backups 3) I need a solution to get VirtualFullBackups on a external / offsite Storage Best regards Toni Toni Burger schrieb am Montag, 10. August 2020 um 16:39:25 UTC+2: > Hello again, > now, I'm sure. My longterm Jobs are marked as archive job type, like > described in the manual (with the script step). Archive Jobs are not > selected by the "PoolUncopiedJobs" selector to create a copy. > > I could select these job with a own sql query: > > SELECT DISTINCT Job.JobId,Job.StartTime FROM Job,Pool WHERE Pool.Name = > 'AI-Longterm' AND Pool.PoolId = Job.PoolId AND Job.Type = 'A' AND > Job.JobStatus IN ('T','W') AND Job.Level = 'F' AND Job.jobBytes > 0 AND > Job.JobId NOT IN (SELECT PriorJobId FROM Job WHERE Type IN ('B','C') AND > Job.JobStatus IN ('T','W') AND PriorJobId != 0) ORDER by Job.StartTime; > > But doing this ... again some question came up. What are the purpose of > Archive-Jobs? Archive Jobs are not available for restore using bconsole. > Even the manual don't describe archive jobs at all. > > https://docs.bareos.org/Configuration/Director.html#job-resource > > Is it the complete wrong direction i try to solve my scenario? > > Best regards > Toni > > Toni Burger schrieb am Freitag, 7. August 2020 um 15:35:03 UTC+2: > >> Hi again, >> >> I setup a Always Incremental bareos configuration, like described hier: >> https://docs.bareos.org/master/TasksAndConcepts/AlwaysIncrementalBackupScheme.html >> >> Most of it is working correct, wihtout the last step. >> What i want to achieve: >> >> 1) Incremental Backups from my clients -> go to AI-Pool [OK] >> 2) Consolidate the incrementals every ~month -> go to >> AI-Consolidated-Pool [OK] >> 3) Make a VirtualFullBackup every 3 Month -> go to AI-Longterm-Pool [OK] >> 4) Copy all Jobs from AI-Longterm-Pool to AI-Longterm-Extern-Pool, >> manually triggerd [not working] >> >> Steps 1-3 are ok. I got a VirtualFullBackup in the AI-Longterm pool: >> >> Choose a query (1-21): 14 >> Enter Volume name: AI-Longterm-0011 >> >> +-------+-----------------+---------------------+------+-------+---------+---------+--------+ >> | jobid | name | starttime | type | level | files >> | gb | status | >> >> +-------+-----------------+---------------------+------+-------+---------+---------+--------+ >> | 4 | VirtualLongTerm | 2020-08-06 22:27:05 | A | F | 247,188 >> | 417.346 | T | >> >> +-------+-----------------+---------------------+------+-------+---------+---------+--------+ >> * >> >> >> This is the pool definition for my AI-Longterm-Pool: >> >> Pool { >> Name = AI-Longterm >> Pool Type = Backup >> Next Pool = AI-Longterm-Extern >> Recycle = yes # Bareos can automatically recycle >> Volumes >> Auto Prune = yes # Prune expired volumes >> Volume Retention = 7 months # How long should jobs be kept? >> Maximum Volume Bytes = 50G # Limit Volume size to something >> reasonable >> Label Format = "AI-Longterm-" >> Volume Use Duration = 23h >> Storage = File >> } >> >> And this my AI-Longertm-Extern-Pool: >> >> Pool { >> Name = AI-Longterm-Extern >> Pool Type = Backup >> Recycle = yes # Bacula can automatically recycle >> Volumes >> AutoPrune = yes # Prune expired volumes >> Volume Retention = 2 years # 2 years fullbacks are stored / >> fullbackup is do> >> Maximum Volume Bytes = 50G # Limit Volume size to something >> reasonable >> Volume Use Duration = 23h >> Storage = ExternFile >> Label Format = AI-Longterm-Extern- >> } >> >> And here is the copy job i definied: >> >> Job { >> Name = "LongtermCopyToExtern" >> Type = Copy >> Selection Type = PoolUncopiedJobs >> Messages = Standard >> Pool = AI-Longterm >> Level = Full >> Full Backup Pool = AI-Longterm >> Write Bootstrap = >> "/media/bareosExternBackup/bareos/bootstrap/LongtermCopyToExtern-%n.bsr" >> } >> >> >> Sadly, if i run this one, no jobs are found to be copied: >> >> 07-Aug 15:18 storageSrv-dir JobId 11: No JobIds found to copy. >> 07-Aug 15:18 storageSrv-dir JobId 11: Bareos storageSrv-dir 19.2.7 >> (16Apr20): >> Build OS: Linux-3.10.0-1062.18.1.el7.x86_64 debian Debian >> GNU/Linux 10 (buster) >> Current JobId: 11 >> Current Job: LongtermCopyToExtern.2020-08-07_15.18.54_04 >> Catalog: "MyCatalog" (From Client resource) >> Start time: 07-Aug-2020 15:18:56 >> End time: 07-Aug-2020 15:18:56 >> Elapsed time: 0 secs >> Priority: 10 >> Bareos binary info: bareos.org build: Get official binaries and >> vendor support on bareos.com >> Termination: Copying -- no files to copy >> >> >> Maybe, it's because the jobs in AI-Longterm are of the type: Archive? How >> to select them? >> >> Or what else I'm missing? >> >> Thanks a lot. >> Toni >> >> -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to bareos-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/98061b83-447b-4e8f-b053-4f30dbbba8e7n%40googlegroups.com.