On 2023-01-19 22:56, Justin Case wrote:
Hi all,
I am trying to keep a copy of all backup jobs on a tier-2 storage. My
first approach was to copy all yet uncopied jobs - but in the
beginning that would be a prohibitive number of copy jobs (hundreds!)
I think it would work for me if I would let Bacula copy all yet
uncopied jobs that ran within the last 24 hours. It seems that the the
only selection type supporting such a thing would be SQLQuery. Or is
there another selection that would make it easier to do this?
Searching the manuals I couldn’t find the schema that I would be able
to use for the SQL query. Whee is this documented?
Are there any examples for this selection typ for copy or migration
jobs?
Hello,
Please check this thread from archives:
https://sourceforge.net/p/bacula/mailman/message/34336222/
In that archive thread there is an SQL query that selects only the
latest
full job along with its differential and all the incremental jobs that
haven't been copied yet.
If you copy only the jobs executed in the last 24h you will not be able
to restore them (using normal restore procedures) without the related
full backup jobs.
Regards
--
Josip Deanovic
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
