Zitat von [email protected]:
Zitat von Marco van Wieringen <[email protected]>:<lst_hoe02 <at> kwsoft.de> writes:Hello, we have a Bareos Install 14.2.2-46 on Linux which is running fine doing disk based backup and virtual full to tape. Now we like to replace the virtual full by a copy job which transfer the disk based full backup to tape. We have therefore tried this copy job: JobDefs { Name = "COPY-Def" Type = Copy Enabled = yes Messages = Standard Pool = SHORT Priority = 20 Write Bootstrap = "/var/lib/bareos/%c.bsr" } # TEST Copy Job Job { Name = "COPY2TAPE-FS02" # Enabled = no JobDefs = "COPY-Def" Client = fs02-fd FileSet = "FS02Full" Schedule = "COPYCycle" Selection Type = SQLQuery Selection Pattern = "SELECT jobid FROM job WHERE clientid='19' AND type='B' AND level='F' AND poolid='5' AND (jobstatus='T' OR jobstatus='W') AND (endtime > (now() - INTERVAL '7 days'))" }Officially the query should return two items I myself use the following (which is a variation on the build in CopyUnCopiedJobs)I will try with two results from SQL query. From reading the manual i thouhgt we only need the jobid:SQLQueryThe SQLQuery selection type, used the Selection Pattern Dir Job as an SQL query to obtain the JobIds to be migrated. The Selection Pattern must be a valid SELECT SQL statement for your SQL engine, and it must return the JobId as the first field of the SELECT.
Adding the starttime to the select let the copy start as expected. Do you need a traceback anyway? If yes i will try to revert the change later and try to create a useful dump later.
Another question: Is it recommended/possible to use data spooling for copy to tape?
Regards Andreas -- 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 [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
smime.p7s
Description: S/MIME Cryptographic Signature
