Re: [Bacula-users] Need some help with copy jobs

2012-01-16 Thread Joe Nyland
Hi,Thanks for your pointer Phil - it seems to be valid now.However, I am still unable to see what this query is doing :-(. If I run it against my catalogue DB, I just get a long list of JobIDs, which don't look right for my SVN_Full pool. I have a feeling I may be over complicating thigs using a

Re: [Bacula-users] Need some help with copy jobs

2012-01-16 Thread Adrian Reyer
On Mon, Jan 16, 2012 at 01:23:37PM +, Joe Nyland wrote: However, I am still unable to see what this query is doing :-(. If I run it against my catalogue DB, I just get a long list of JobIDs, which don't look right for my SVN_Full pool. I have a feeling I may be over complicating thigs

Re: [Bacula-users] Need some help with copy jobs

2012-01-16 Thread Joe Nyland
Thanks for the explanation Andrian. In the meantime, I've given the 'PoolUncopiedJobs' option a go, and it appears to work just as well as the SQL query that I originally included in my email. However, Im still stuck in the loop mentioned earlier - I still appear to be copying two jobs, then

Re: [Bacula-users] Need some help with copy jobs

2012-01-15 Thread Joe Nyland
Hi there, Thanks for replying. I had thought of doing it with a bash script like this, yes, but it seems (According to http://www.bacula.org/manuals/en/concepts/concepts/Migration_Copy.html) that Bacula is capable of doing what I want. It is preferred to use Bacula for this task, so that

Re: [Bacula-users] Need some help with copy jobs

2012-01-15 Thread Adrian Reyer
On Sat, Jan 14, 2012 at 11:46:21PM +, Joe Nyland wrote: I have a copy job as follows: Selection Type = SQLQuery Selection Pattern = SELECT DISTINCT Job.JobId,Job.StartTime FROM Job,Pool WHERE Pool.Name = 'SVN_Full' AND Pool.PoolId = Job.PoolId AND Job.Type = 'B'

Re: [Bacula-users] Need some help with copy jobs

2012-01-15 Thread Joe Nyland
Hi, Thanks for you input. Unfortunately, I am no SQL expert, and I get the following when trying to run your selection query against my Bacula MySQL DB: select a.JobId from Job AS a JOIN Pool AS b ON a.PoolId=b.PoolId AND b.Name!='ARCH' AND b.Name!='TAPE' WHERE a.Type='B' AND a.JobID NOT

Re: [Bacula-users] Need some help with copy jobs

2012-01-15 Thread Phil Stracchino
On 01/15/2012 04:17 PM, Joe Nyland wrote: select a.JobId from Job AS a JOIN Pool AS b ON a.PoolId=b.PoolId AND b.Name!='ARCH' AND b.Name!='TAPE' WHERE a.Type='B' AND a.JobID NOT IN (SELECT PriorJobId FROM Job AS c JOIN Pool AS d ON c.PoolId=d.PoolId AND

[Bacula-users] Need some help with copy jobs

2012-01-14 Thread Joe Nyland
Hello there, I'm currently trying to build a backup procedure that will backup my servers to an external disk, then copy the backups to my iMac, so that I have another copy of the data, if my main server were to die, along with the external backup HDD. I only want to keep the copied volumes

Re: [Bacula-users] Need some help with copy jobs

2012-01-14 Thread starlight
Why not just write a shell script to copy the archive volumes and either run it as a type=Admin job or from cron? That's what I do. Have it set up so each client has it's own pool of use-once volumes with the date-time in the name. Simple 'touch' and 'find -newer' commands figure out what to

[Bacula-users] Need Some Help with Backup Strategy

2011-09-27 Thread Palmer, David W.
Hello, I need some input on my backup strategy. Here is my setup: 1 - LTO3 24 slot autochanger with one drive. 1 - 6.5 TB Openfiler SAN 1 - 17 TB Openfiler SAN 30 Servers with around 8 TB of Data. I am trying to figure out a backup schedule that will allow all the data to be backed up

[Bacula-users] Need some help

2011-08-15 Thread Ignacio Cardona
Dear all, I will be very glad if someone could help me. I have decided after many recommendations to implement Bacula software in the environment of my e-commerce. The version that I'm trying to test is Bacula 5.0.3. I have started reading the docs and all the stuff but I am completly

Re: [Bacula-users] Need some help

2011-08-15 Thread Eric Pratt
2011/8/15 Ignacio Cardona ignaciocard...@gmail.com: Dear all,     I will be very glad if someone could help me.  I have decided after many recommendations to implement Bacula software in the environment of my e-commerce. The version that I'm trying to test is Bacula 5.0.3. I have

Re: [Bacula-users] Need some help

2009-06-19 Thread Mark Nesterovych
Ok. Using script is good for my issue. Thanks for idea. But I have once more question. I've installed bacula at my ubuntu-server 9.04. I can't find awk script which is used to backup catalog. Folder /etc/bacula/scripts is empty. May be scripts located in another package. Can anybody point me which

[Bacula-users] Need some help

2009-06-18 Thread Mark Nesterovych
Hello to everybody. I am newbie with bacula. Can't find information in manual. May be somebody already implemented what I want. I have Incremental backups from few servers during working days and full at weekend. Backups located at File storage. I want to create a new Job which will backup

Re: [Bacula-users] Need some help

2009-06-18 Thread Mike Eggleston
On Thu, 18 Jun 2009, Mark Nesterovych might have said: Hello to everybody. I am newbie with bacula. Can't find information in manual. May be somebody already implemented what I want. I have Incremental backups from few servers during working days and full at weekend. Backups located

Re: [Bacula-users] Need some help

2009-06-18 Thread Mark Nesterovych
On Thu, 2009-06-18 at 10:42 -0500, Mike Eggleston wrote: Is that what you're wanting? Yep. But how can I point volumes that have last info ? Not every one in the pool. -- Mark Nesterovych marknesterov...@itt-consulting.com ITT Consulting

Re: [Bacula-users] Need some help

2009-06-18 Thread Mike Eggleston
On Thu, 18 Jun 2009, Mark Nesterovych might have said: On Thu, 2009-06-18 at 10:42 -0500, Mike Eggleston wrote: Is that what you're wanting? Yep. But how can I point volumes that have last info ? Not every one in the pool. I have a Run Before Job script named pre-tape-backup.sh that does

Re: [Bacula-users] Need some help

2009-06-18 Thread Fahrer, Julian
Nesterovych Cc: bacula-users Betreff: Re: [Bacula-users] Need some help On Thu, 18 Jun 2009, Mark Nesterovych might have said: On Thu, 2009-06-18 at 10:42 -0500, Mike Eggleston wrote: Is that what you're wanting? Yep. But how can I point volumes that have last info ? Not every one in the pool

Re: [Bacula-users] Need some help

2006-03-09 Thread Thomas E. Ruth
Hello, I have the following in my bacula-sd.conf file. With these directives, the tape ejects after the first is full, and when I put in another, it will automatically poll and remount it after about 5 minutes. Works great! The important ones are Volume Poll Interval, Automatic Mount, Close

Re: [Bacula-users] Need some help

2006-03-08 Thread Ryan Novosielski
I'm forgetting the name of the directive. I don't think an eject is possible, at all or perhaps without custom scripting, but you CAN have the drive mount automatically. Search the manual for Volume Poll Interval or something like that... can't remember the name. That should help. Randy

[Bacula-users] Need some help

2006-03-07 Thread Randy
I have installed and configured, bacula, however, I am having a minor problem. The backup is too large for one tape and so it will have to span tapes. Is there a way to get bacula to eject the tape when it is full and automatically mount the next tape when it is inserted? Randy Morgan --