Hi Gandalf, while I do not have exactly the same requirements, possibly the 
information below will be helpful.

You do not mention it but I am assuming you are doing backups to disk.  You 
also do not mention using the tape device for any other backups so I will 
assume you do not(If you do, there is some trickery you may need to employ).


It sounds like you need to modify your Full Pool for each client, add the "Next 
Pool" resource and point it at the Tape drive pool(lets call it Tape).

The following copy job is what works for me :


Job {
  Name = "Offsite Backup"
  Client = backup-fd
  JobDefs = "DefaultJob"
  Type = Copy
  FileSet = "Full Set"
  Priority = 11
  SpoolData = No
  Messages = ErrorOnly
  Schedule = "Offsite Schedule"
  Pool = File

  Selection Type = SQL Query
  Selection Pattern = "select * from offsite_backups"
}


NOTES : FileSet can be anything, it's required for a job definition but totally 
ignored by copy
        Pool can be anything BUT I found that in the pool definition Storage 
must be the same as the source for the copy jobs and Next Pool must point to 
where you want the copy jobs to go

My SQL Query in the job definition is overly simple because I use a stored 
query in the DB (query was too long for bacula)


Here is a simplified version of my query (postgres, someone with more DB 
experience will have to help if you need to change this):

SELECT max(j.jobid) AS jobid, j.name, max(j.starttime) AS starttime
FROM job j
JOIN pool p ON j.poolid = p.poolid
WHERE p.name = 'File'::text AND (j.name = ANY (ARRAY['server 1 Backup'::text, 
'Server 2 Backup'::text, 'Crazy Server Backup'::text ])) AND j.type = 
'B'::bpchar AND j.level = 'F'::bpchar AND (j.jobstatus = ANY 
(ARRAY['T'::bpchar, 'W'::bpchar]))
AND NOT (j.jobid IN ( SELECT job.priorjobid
FROM job
WHERE (job.type = ANY (ARRAY['B'::bpchar, 'C'::bpchar])) AND (job.jobstatus = 
ANY (ARRAY['T'::bpchar, 'W'::bpchar])) AND job.priorjobid = 0))
GROUP BY j.name
ORDER BY max(j.jobid);


You may run into problems if you have multiple source pools.  I am selecting 
particular backups by name, you could drop this and choose all backups if you 
wish.

The query should return the highest ID number for each job name ( type : F 
(Full), status : T(OK) or W(warnings only, no errors)









-----Original Message-----
From: Gandalf Corvotempesta [mailto:newsletter-ale AT guest DOT net]
Sent: Thursday, May 03, 2012 6:02 AM
To: bacula-users AT lists.sourceforge DOT net
Subject: [Bacula-users] DELL TL2000

Hi all,
I have a bacula server configured to use
one pool for every client host and for every
backup level.

In this way, a single client has 3 pool: Full, Incr, Diff

What i would like to do is to copy the latest full pool for
each client to a tape library.

I've tried to configurare a Copy job with no success.
Do you have some docs or example that will allow me to
copy more then one pool to a tape library at once?

Thank you.


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

This electronic mail transmission and any accompanying attachments contain 
confidential information intended only for the use of the individual or entity 
named above. Any dissemination, distribution, copying or action taken in 
reliance on the contents of this communication by anyone other than the 
intended recipient is strictly prohibited. If you have received this 
communication in error please immediately delete the e-mail and either notify 
the sender at the above e-mail address or by telephone at +1 250.386.5323.

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users