Thank you so much Josip, that sounds perfect. I will run tests with your query.
> On 20. Jan 2023, at 00:07, Josip Deanovic <djosip+n...@linuxpages.net> wrote: > > 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/ > <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 <mailto:Bacula-users@lists.sourceforge.net> > https://lists.sourceforge.net/lists/listinfo/bacula-users > <https://lists.sourceforge.net/lists/listinfo/bacula-users>
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
