Re: [Bacula-users] DELL TL2000
2012-05-10 12:30:51
I think you have two options...
Probably the simplest and most straight forward would be to create a copy job
for each pool, then a simple SQL select query for that pool to grab the latest
full backup. This seems to be consistent with the rest of your configuration
and probably the recommended way to go.
However, if all of your pools have the same storage = defined for them you can
probably get away with a single SQL query that will grab the required backups.
Something like the following query :
SELECT max(j.jobid) AS jobid, j.name, max(j.starttime) AS starttime FROM job j
WHERE j.type = 'B' AND j.level = 'F' AND (j.jobstatus = ANY (ARRAY['T', 'W']))
AND NOT (j.jobid IN (SELECT job.priorjobid FROM job WHERE (job.type = ANY
(ARRAY['B', 'C'])) AND (job.jobstatus = ANY (ARRAY['T', 'W'])) AND
job.priorjobid = 0)) GROUP BY j.name ORDER BY max(j.jobid);
Do test the query in your DB to ensure it returns the expected list of backup
jobs, if I understand the bacula DB correctly, this should give you the latest
Full(highest job ID number with level F and type B) backup job for every unique
job name. You may want to add some more restrictions like a list of what pools
you want jobs selected from, or a list of job names to limit your selection to.
Poke around in the bacula db tables and I'm sure you'll get the idea pretty
quick.
-----Original Message-----
From: Gandalf Corvotempesta [mailto:newsletter-ale AT guest DOT net]
Sent: Thursday, May 10, 2012 8:22 AM
To: Radosław Korzeniewski
Cc: bacula-users
Subject: Re: [Bacula-users] DELL TL2000
Il giorno gio, 10/05/2012 alle 16.37 +0200, Radosław Korzeniewski ha
scritto:
> It depends how your disk polls are arranged (sorry I don't have your
> very first email). If you have only one pool, then it could be
> achieved by only one job with a proper selection criteria and pattern
> (especially a dedicated sql statement). If you have more pools then
> you have to prepare a number of copy jobs.
I have one pool for each backup level for each client.
For example: 50 clients, 3 backup levels (F, D, I) = 150 Pools
- We have to create 150 Copy Job?
- How can I select the most recent backup-set for a client ?
- Should I create a 150 Tape storage resources?
I'm really a newbie on Bacula, a working configuration is accepted. :)
------------------------------------------------------------------------------
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: [Bacula-users] DELL TL2000, (continued)
- Re: [Bacula-users] DELL TL2000, Gandalf Corvotempesta
- Re: [Bacula-users] DELL TL2000, Tim Krieger
- Re: [Bacula-users] DELL TL2000, Gandalf Corvotempesta
- Re: [Bacula-users] DELL TL2000, John Drescher
- Re: [Bacula-users] DELL TL2000, Gandalf Corvotempesta
- Re: [Bacula-users] DELL TL2000, John Drescher
- Re: [Bacula-users] DELL TL2000, Gandalf Corvotempesta
- Re: [Bacula-users] DELL TL2000, John Drescher
- Re: [Bacula-users] DELL TL2000, Radosław Korzeniewski
- Re: [Bacula-users] DELL TL2000, Gandalf Corvotempesta
- Re: [Bacula-users] DELL TL2000,
Tim Krieger <=
- Re: [Bacula-users] DELL TL2000, Gandalf Corvotempesta
- Re: [Bacula-users] DELL TL2000, Gandalf Corvotempesta
- Re: [Bacula-users] DELL TL2000, Gandalf Corvotempesta
- Re: [Bacula-users] DELL TL2000, Gandalf Corvotempesta
- Re: [Bacula-users] DELL TL2000, John Drescher
- Re: [Bacula-users] DELL TL2000, Gandalf Corvotempesta
- Re: [Bacula-users] DELL TL2000, John Drescher
- Message not available
- [Bacula-users] Fwd: DELL TL2000, John Drescher
- Re: [Bacula-users] DELL TL2000, Gandalf Corvotempesta
- Re: [Bacula-users] DELL TL2000, Tim Krieger
|
|
|