[Bacula-users] Copy Job of a bunch of backups?

2022-05-27 Thread Pierre Bernhardt



Hello,

I create a full backup each 1st Sunday, diff backups of rest of Sundays, 
incremental backups each day.

I would create a copy after the first day of a month backup has been made. The 
data should be copied
from the last backup however it has been made.

So for the moment I create a restore before a given date/time and create a full 
backup of these
restore to a special tape.

Is there a "virtual copy" possible which which I can configure to create one 
copy job based on backup
before a specified time which made the same without having restore them before?


Thx,
Pierre



___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Copy Job of a bunch of backups?

2022-05-27 Thread Josip Deanovic

On 2022-05-27 11:27, Pierre Bernhardt wrote:

Hello,

I create a full backup each 1st Sunday, diff backups of rest of
Sundays, incremental backups each day.

I would create a copy after the first day of a month backup has been
made. The data should be copied
from the last backup however it has been made.

So for the moment I create a restore before a given date/time and
create a full backup of these
restore to a special tape.

Is there a "virtual copy" possible which which I can configure to
create one copy job based on backup
before a specified time which made the same without having restore them 
before?



Hi Pierre

The solution would be to use SQLQuery selection type in your Copy job.
These are the options you are looking for:

Selection Type = SQLQuery
Selection Pattern = ""

You just need to devise a query that will return the list of Job IDs
you want to copy in the first column of the query output.


Regards!

--
Josip Deanovic


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users


Re: [Bacula-users] Copy Job of a bunch of backups?

2022-05-27 Thread Phil Stracchino

On 5/27/22 05:27, Pierre Bernhardt wrote:


Hello,

I create a full backup each 1st Sunday, diff backups of rest of Sundays, 
incremental backups each day.

I would create a copy after the first day of a month backup has been made. The 
data should be copied
from the last backup however it has been made.

So for the moment I create a restore before a given date/time and create a full 
backup of these
restore to a special tape.

Is there a "virtual copy" possible which which I can configure to create one 
copy job based on backup
before a specified time which made the same without having restore them before?



If I understand correctly what you are asking, you could, hypothetically 
speaking, do a Virtual Full backup (i.e. construct a synthetic full 
backup job within the database from already-existing backups), and then 
run a Copy job to copy that Virtual Full job to a new tape.



--
  Phil Stracchino
  Babylon Communications
  ph...@caerllewys.net
  p...@co.ordinate.org
  Landline: +1.603.293.8485
  Mobile:   +1.603.998.6958


___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users