[Bacula-users] Strange problem with multiple backup on the same FD
hello, i've got a strange problem on one of my FD on which i make multiple backup simultaneously. I'be got 2 jobs running with different directory to backup (as the complete server has a big volume of data, i've split backup in 2), but one of these return an error Fatal error: Authorization key rejected by Storage daemon. I don't understand why because theses 2 jobs use the same FD with the same password. I check the configuration and it's the same (except for the directories in the FileSet) I also allowed up to 10 concurrents jobs on the client side and up to 20 on the server side, so i don't think the problem is related to that point. Does anyone has an idea ? Thanks +-- |This was sent by pierre.chevall...@option-service.fr via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Auto recycle volume
Hello all. Im confused about recycle options in Bacula 2.4.4. I have such options on some pools: Recycle = yes AutoPrune = yes Volume Retention = 30 days Maximum Volumes = 3 Maximum Volume Bytes = 10G As I understand - volume what older than 30 day will be recycled if it FULL. BUT - how can I set to recycle volume if all volumes are FULL? For example I fill all 3 volumes with 10G each by 20 days. How to make auto recycle of latest volume? -- Best regards, Proskurin Kirill -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Strange problem with Bacula
Cedric Tefft wrote: Reynier Pérez Mira wrote: Hi: Cedric Tefft wrote: Reynier Pérez Mira wrote: Probably /tmp. Run show variables where Variable_name = 'tmpdir'; in mysql to find out for sure. I use PostgreSQL instead of MySQL. What this query should return? How I can run the same query in Postgres? I suspect it may be a thing of the postgres tablespaces because I use the default tablespace. I don't know what the equivalent would be in Postgres, or if there is an equivalent. What you're looking for is the directory Postgres uses when it needs to write temporary tables to disk. I suggest checking the Postgres manual and/or Google. I tought this lines are a little suspicious, don't you think? 23-Sep 03:17 serverbacula-dir JobId 2215: Fatal error: sql_create.c:825 Fill File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5)SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name): ERR=ERROR: could not write to hash-join temporary file: No space left on device Well, it's an ERROR message, so it's definitely not good, but suspicious? No. Be aware that if the problem really is a lack of temp space, you would probably only see /tmp at or near capacity WHILE bacula is actively trying to update the database (i.e. not before or after). So /tmp will be full capacity WHILE bacula try to save data? Is that what you said? Yes. All of this come due to the use of batch-insert option ( compile option ) So to accelerate the insert of records into the db, bacula-dir write each record during the backup into Batch temp table. After all records are written to the sd, dir try to make one big transaction with the db. So during the backup this file is written on disk normally into /tmp perharps elsewhere /var/lib/bacula don't know exactly where. As your postgresql claim to not have suffisant space for hash-join temporary file you should also check where postgresql is working /var/lib/pgsql under openSUSE for example ... -- Bruno Friedmann -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Trouble installing on RHEL 5
I just installed bacula on my RHEL 5 server using rpm bacula-mysql-3.0.2-1.el5.i386.rpm I have a few questions: 1. Where did it install it? Can't find it anywhere but it says its installed 2. The database portion failed as it never prompted me for the database password. Is there a How-To on manually creating the database? Thanks in advance for now. John J. Boris, Sr. JEN-A-SyS Administrator Archdiocese of Philadelphia Remember! That light at the end of the tunnel Just might be the headlight of an oncoming train! -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Auto recycle volume
-Original Message- From: Proskurin Kirill [mailto:proskurin...@fxclub.org] Sent: Fri 25/09/2009 11:24 To: bacula-users@lists.sourceforge.net Subject: [Bacula-users] Auto recycle volume Hello all. Im confused about recycle options in Bacula 2.4.4. I have such options on some pools: Recycle = yes AutoPrune = yes Volume Retention = 30 days Maximum Volumes = 3 Maximum Volume Bytes = 10G As I understand - volume what older than 30 day will be recycled if it FULL. BUT - how can I set to recycle volume if all volumes are FULL? For example I fill all 3 volumes with 10G each by 20 days. How to make auto recycle of latest volume? -- Best regards, Proskurin Kirill -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users You will have to either change the retention period or buy more tapes. Bacula will not auto recycle a volume that has not reached it's retention period. You can manually mark a tape to recycle through bconsole (update - Volume - Status). John The information in this message is intended solely for the addressee and should be considered confidential. Publishing Technology does not accept legal responsibility for the contents of this message and any statements contained herein which do not relate to the official business of Publishing Technology are neither given nor endorsed by Publishing Technology and are those of the individual and not of Publishing Technology. This message has been scanned for viruses using the most current and reliable tools available and Publishing Technology excludes all liability related to any viruses that might exist in any attachment or which may have been acquired in transit.winmail.dat-- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Trouble installing on RHEL 5
I just installed bacula on my RHEL 5 server using rpm bacula-mysql-3.0.2-1.el5.i386.rpm I have a few questions: 1. Where did it install it? Can't find it anywhere but it says its installed The binaries go /usr/sbin /sbin etc.. 2. The database portion failed as it never prompted me for the database password. Is there a How-To on manually creating the database? There should now be /etc/bacula for the config files. It may have a scripts subfolder which has sql-scripts for the database creation. The passwords go to /etc/bacula/bacula-dir.conf -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Trouble installing on RHEL 5
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John BORIS wrote: I just installed bacula on my RHEL 5 server using rpm bacula-mysql-3.0.2-1.el5.i386.rpm I have a few questions: 1. Where did it install it? Can't find it anywhere but it says its installed rpm -ql rpmname shows you, if I'm not mistaken. If it's not that, it's very similar. man rpm. - -- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer II |$| |__| | | |__/ | \| _| |novos...@umdnj.edu - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/CST - NJMS Medical Science Bldg - C630 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkq80fMACgkQmb+gadEcsb4I/wCfTpGuyjO3KNe6banrUeMAjX1C Xp8AoMIusKmQrBlILUsi2QSr3MQKzmiz =jrJ1 -END PGP SIGNATURE- attachment: novosirj.vcf-- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Auto recycle volume
Juche Kirill, For example I fill all 3 volumes with 10G each by 20 days. How to make auto recycle of latest volume? As far as I understood, this is not possible. If you setup your backup strategy you define that you will be Able to recycle files up to 30 Days. If your storage space runs out, and you have to recycle volumes before that time, this is a lost of level of service. This will never be done automatcally. This has to be done by you by hand, so that you know, what you are doing, and that you should probably increase storage space. Purge (or prune I allways mix them up) the Volumes by hand. Hannes -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Trouble installing on RHEL 5
Thanks to Ryan and Jari for the quick response. I found what I needed. The issue is the bacula rpm and scripts assume that the mysql installation doesn't require a password. I modified the scripts to prompt for the password and things proceeded just fine. I previously had an installation of bacula on this server but it was under Fedora Core. I since had moved it to RHEL because of a major failure in hardware. Now I just have to recreate things. Thanks again. John J. Boris, Sr. JEN-A-SyS Administrator Archdiocese of Philadelphia Remember! That light at the end of the tunnel Just might be the headlight of an oncoming train! Ryan Novosielski novos...@umdnj.edu 9/25/2009 10:21 AM -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John BORIS wrote: I just installed bacula on my RHEL 5 server using rpm bacula-mysql-3.0.2-1.el5.i386.rpm I have a few questions: 1. Where did it install it? Can't find it anywhere but it says its installed rpm -ql rpmname shows you, if I'm not mistaken. If it's not that, it's very similar. man rpm. - -- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer II |$| |__| | | |__/ | \| _| |novos...@umdnj.edu - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/CST - NJMS Medical Science Bldg - C630 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkq80fMACgkQmb+gadEcsb4I/wCfTpGuyjO3KNe6banrUeMAjX1C Xp8AoMIusKmQrBlILUsi2QSr3MQKzmiz =jrJ1 -END PGP SIGNATURE- -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Auto recycle volume
Proskurin Kirill wrote: Hello all. Im confused about recycle options in Bacula 2.4.4. I have such options on some pools: Recycle = yes AutoPrune = yes Volume Retention = 30 days Maximum Volumes = 3 Maximum Volume Bytes = 10G As I understand - volume what older than 30 day will be recycled if it FULL. BUT - how can I set to recycle volume if all volumes are FULL? For example I fill all 3 volumes with 10G each by 20 days. How to make auto recycle of latest volume? *Use Purge Oldest Volume = yes * -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Simple restore question...
Hello Group! I can't seem to figure out how restore to a windows xp machine other that the original client. I have tried putting everything in quotes but I believe I'm simply doing something wrong. I would like the restore to go to the machine at 192.168.212.17 and into the my documents\public folder. Could someone be so kinda as to tell me what the path should be??? Mark Rogers -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Label command failed
Hi,
I use bacula 2.4.4 in debian lenny and etch with FileStorages of 2 servers :
- localhost named bacula-srv (lenny)
- remote named bombarde (etch with backports)
The bacula-director is installed of bacula-srv.
The true server storage is bombarde and i use bacula-srv for storage
only for test.
I do a label command of FileStorage at bacula-srv :
Connecting to Storage daemon FileStorage at bacula-srv:9103 ...
Sending label command for Volume DD-SITE01-03 Slot 0 ...
3000 OK label. VolBytes=202 DVD=0 Volume=DD-SITE01-03
Device=FileStorage (/home/bacula)
Catalog record for Volume DD-SITE01-03, Slot 0 successfully created.
Requesting to mount FileStorage ...
3906 File device FileStorage (/home/bacula) is always mounted.
All is ok.
I do a label command of the FileStorageBombarde :
Connecting to Storage daemon FileStorageBombarde at bombarde:9103 ...
Sending label command for Volume DD-SITE01-04 Slot 0 ...
3000 OK label. Volume=DD-SITE01-04 Device=FileStorageBombarde
(/home/bacula)
Label command failed for Volume DD-SITE01-04.
Do not forget to mount the drive!!!
In finally, the filestorage exist in bombarde:/home/bacula and label is
ok but the FileStorage is not in the mysql database.
- Configuration in bombarde :
* bacula-sd.conf
Storage { # definition of myself
Name = bombarde-sd
SDPort = 9103 # Director's port
WorkingDirectory = /var/lib/bacula
Pid Directory = /var/run/bacula
Maximum Concurrent Jobs = 20
SDAddress = ip bombarde
}
Director {
Name = bacula-dir
Password = password
}
Device {
Name = FileStorageBombarde
Media Type = File
Archive Device = /home/bacula
LabelMedia = yes; # lets Bacula label unlabeled media
Random Access = Yes;
AutomaticMount = yes; # when device opened, read it
RemovableMedia = no;
AlwaysOpen = no;
}
- Configuration in bacula-srv :
* bacula-sd.conf
Storage { # definition of myself
Name = bacula-sd
SDPort = 9103 # Director's port
WorkingDirectory = /var/lib/bacula
Pid Directory = /var/run/bacula
Maximum Concurrent Jobs = 20
SDAddress = 127.0.0.1
}
Director {
Name = bacula-dir
Password = password
}
Device {
Name = FileStorage
Media Type = File
Archive Device = /home/bacula
LabelMedia = yes; # lets Bacula label unlabeled media
Random Access = Yes;
AutomaticMount = yes; # when device opened, read it
RemovableMedia = no;
AlwaysOpen = no;
}
* bacula-dir.conf
#--STORAGES
DEFINE---
# Definition of file storage device
Storage {
Name = FileStorage
# Do not use localhost here
Address = bacula# N.B. Use a fully qualified name here
SDPort = 9103
Password = password
Device = FileStorage
Media Type = File
}
# Definition of file storage device
Storage {
Name = FileStorageBombarde
# Do not use localhost here
Address = bombarde# N.B. Use a fully qualified name here
SDPort = 9103
Password = password
Device = FileStorageBombarde
Media Type = File
}
I search a solution since 2 days :(
Do you have an idea ?
Grégory
--
Come build with us! The BlackBerryreg; Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9#45;12, 2009. Register now#33;
http://p.sf.net/sfu/devconf
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] vchanger script syntax error
I downloaded the vchanger script and when I test it I get this: /etc/bacula/vchanger: 49: Syntax error: ( unexpected Any ideas as to why? TIA Glyn +-- |This was sent by g...@cirrus.co.za via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] vchanger script syntax error
Not exactly, but the howto on the Bacula wiki is quite outdated. The script has been deprecated in favor of a C/C++ executable. See http://sourceforge.net/projects/vchanger/. glynd wrote: I downloaded the vchanger script and when I test it I get this: /etc/bacula/vchanger: 49: Syntax error: ( unexpected Any ideas as to why? TIA Glyn +-- |This was sent by g...@cirrus.co.za via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Simple restore question...
Nevermind, I was able to figure it out... Mark Rogers -Original Message- From: Mark Rogers [mailto:m.rog...@fmpco.com] Sent: Friday, September 25, 2009 12:53 PM To: bacula-users@lists.sourceforge.net Subject: [Bacula-users] Simple restore question... Hello Group! I can't seem to figure out how restore to a windows xp machine other that the original client. I have tried putting everything in quotes but I believe I'm simply doing something wrong. I would like the restore to go to the machine at 192.168.212.17 and into the my documents\public folder. Could someone be so kinda as to tell me what the path should be??? Mark Rogers -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Anyone written any handy queries (query.sql)???
On Tue, Aug 11, 2009 at 02:39:39PM -0400, John Lockard wrote: I have modified my query.sql to include some queries that I use frequently and I thought maybe someone else would find them useful additions. Also, I was wondering if anyone had queries which they find useful and would like to share. In my setup, I need to rotate tapes on a weekly basis to keep offsites in case of emergency, so I need to find certain groups of tapes for easy removal and it's easier to group them in query output than having to scan down a 57 item long list and pick out the ones I need (and other similar needs). I hope someone finds this useful, -John SNIP I've just done another one which might be useful... I keep backups on disk for about a week over a month, then I migrate my Differential and Full backups to tape for safe keeping. Bacula doesn't purge media when all jobs from a virtual tape have been migrated to physical tape, so the disk jobs stay around for the full life of the job. In my case that means my Full backups would live on disk for 9 months, even though they were migrated to tape almost 8 months ago. So, I need a way to find all MediaId's which have had *ALL* of their jobs migrated to tape so that I can purge them. Here's what I've come up with. (If there's an easier way to do this, please tell me). (Works on MySQL) :Test List Migrated Jobs stored on Media *Order by (Job or Media): !DROP TABLE tempmig; !DROP TABLE tempmig2; !DROP TABLE tempmig3; CREATE TABLE tempmig (MediaId INT, Type BINARY(1)); CREATE TABLE tempmig2 (MediaId INT, Type BINARY(1)); CREATE TABLE tempmig3 (MediaId INT NOT NULL); INSERT INTO tempmig SELECT JobMedia.MediaId,Job.Type FROM Job,JobMedia,Media WHERE JobMedia.MediaId=Media.MediaId AND Job.JobId=JobMedia.JobId AND Job.Type='M'; INSERT INTO tempmig2 SELECT JobMedia.MediaId,Job.Type FROM Job,JobMedia,Media WHERE tempmig.MediaId=JobMedia.MediaId AND Job.JobId=JobMedia.JobId AND Job.Type!='M'; INSERT INTO tempmig3 SELECT tempmig.MediaId FROM tempmig LEFT JOIN tempmig2 ON tempmig2.MediaId = tempmig.MediaId WHERE tempmig2.MediaId IS NULL; SELECT DISTINCT Job.JobId,JobMedia.MediaId,Job.Name,Job.Type,Job.Level,Job.JobStatus AS Status,Job.JobFiles AS Files,Job.JobBytes/(1024*1024*1024) AS GB FROM JobMedia,Job,tempmig3 WHERE JobMedia.JobId=Job.JobId AND JobMedia.MediaId=tempmig3.MediaId ORDER by JobMedia.%1Id ASC; !DROP TABLE tempmig; !DROP TABLE tempmig2; !DROP TABLE tempmig3; -John -- No matter how sophisticated you may be, a large granite mountain cannot be denied - it speaks in silence to the very core of your being - Ansel Adams --- John M. Lockard | U of Michigan - School of Information Unix and Security Admin | 1214 SI North - 1075 Beal Ave. jlock...@umich.edu |Ann Arbor, MI 48109-2112 www.umich.edu/~jlockard | 734-615-8776 | 734-647-8045 FAX --- -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Volume retention with Migration
I've read through the docs and can't find a definitive answer to this. We back-up to a Data Domain box, then migrate the jobs after some period of time off to tape for archive. It seems that if all the jobs are migrated off a volume, but the volume is not past it's retention period then the volume is not recycled. What I want to do is keep the backup on the Data Domain box for 30 days and then migrate it off to tape. I've set the volume retention for 45 days as our migration jobs have been taking a long time since it reads the whole volume for even KB of data. I don't want the volume to be recycled before all the jobs are migrated, but I want it recycled before the retention period if all the jobs are migrated. Any ideas will be appreciated. Thanks, Robert LeBlanc Life Sciences Undergraduate Education Computer Support Brigham Young University -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Volume retention with Migration
I had a patch submitted a while back for there to be an option for this (you cannot currently do it natively), but it has not been applied to the main code last I looked. Let me know off list if you feel like running unsupported patches and I'll send you a copy, or you can alternately check the bacula-devel archives for it. -Blake From: Robert LeBlanc [mailto:rob...@leblancnet.us] Sent: Friday, September 25, 2009 3:24 PM To: bacula-users Subject: [Bacula-users] Volume retention with Migration I've read through the docs and can't find a definitive answer to this. We back-up to a Data Domain box, then migrate the jobs after some period of time off to tape for archive. It seems that if all the jobs are migrated off a volume, but the volume is not past it's retention period then the volume is not recycled. What I want to do is keep the backup on the Data Domain box for 30 days and then migrate it off to tape. I've set the volume retention for 45 days as our migration jobs have been taking a long time since it reads the whole volume for even KB of data. I don't want the volume to be recycled before all the jobs are migrated, but I want it recycled before the retention period if all the jobs are migrated. Any ideas will be appreciated. Thanks, Robert LeBlanc Life Sciences Undergraduate Education Computer Support Brigham Young University -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
