[Bacula-users] Wakeonlan in bacula
Hello. I have checked a few tutorials in order to do wake on lan with bacula. I have the following problem now: I can wake the target machine with the wakeonlan command and I can also execute it as bacula user, however when I use the command in a job, it does not seem to work at all. This is the job in the job in the bacula-dir.conf I want to run before the actual backup jobs: Job { Name = WakeOnLan Type = Admin client = ubuntu-fd Fileset = None RunScript { RunsWhen = Always Command = wakeonlan -f /etc/bacula/adresses.wol } Pool = File Storage = ubuntu-sd messages = Standard Priority = 5 } It simply gives me an OK-Message after running, so i am not sure what the problem could be. Does anybody have any siggestions? Regards, Florian S. -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Switch Volume at end of month
Hello. I would like to use a Volume for the duration of one month and after the last backup of a month, I want to change the status of the Volume to Used or Full. I use the Volumes this long to have all Backup-Data from one monthly cycle in one file. I figured out how to check, if it is the last day of the month, but I am not sure how to automatically change the status of the specific Volume that has been used till then. Any suggestions are appreciated. Regards, Florian S. -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Wakeonlan in bacula
Hello. I figured out the problem myself. I merely forgot to restart the director. Regards, Florian S. Am 15.09.2014 um 07:58 schrieb Florian: Hello. I have checked a few tutorials in order to do wake on lan with bacula. I have the following problem now: I can wake the target machine with the wakeonlan command and I can also execute it as bacula user, however when I use the command in a job, it does not seem to work at all. This is the job in the job in the bacula-dir.conf I want to run before the actual backup jobs: Job { Name = WakeOnLan Type = Admin client = ubuntu-fd Fileset = None RunScript { RunsWhen = Always Command = wakeonlan -f /etc/bacula/adresses.wol } Pool = File Storage = ubuntu-sd messages = Standard Priority = 5 } It simply gives me an OK-Message after running, so i am not sure what the problem could be. Does anybody have any siggestions? Regards, Florian S. -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] No files restored but disk space used?
Hello, everyone. I am doing final tests with my bacula setup and ran into some weird behavior. I set up an autochanger storage and am currently using the same device for backup and restore. I did a backup of the entire partition E:/ and browsed the files. Everything was there. Then I tried to restore the files to test-folder (avoiding overwrite). Bacula created the new Folder E:/Restore/ and the BAT told me the restore was compelted successfully after about 10 minutes. I opened the folder and it was empty though. Strangely enough, the emount of disk space in use on the harddrive increased. So far I don't have the slightest idea, what the problem may be... When I first tested bacula on a virtual machine, only backing up 2 small files, it worked perfectly fine. Regards, Florian S. -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] No files restored but disk space used?
Hi Floarian, 2014-09-15 10:38 GMT+02:00 Florian florian.spl...@web.de: Hello, everyone. I am doing final tests with my bacula setup and ran into some weird behavior. I set up an autochanger storage and am currently using the same device for backup and restore. I did a backup of the entire partition E:/ and browsed the files. Everything was there. Then I tried to restore the files to test-folder (avoiding overwrite). Bacula created the new Folder E:/Restore/ and the BAT told me the restore was compelted successfully after about 10 minutes. I opened the folder and it was empty though. Strangely enough, the emount of disk space in use on the harddrive increased. So far I don't have the slightest idea, what the problem may be... When I first tested bacula on a virtual machine, only backing up 2 small files, it worked perfectly fine. Regards, Florian S. -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users When restoring an entire drive under windows, the created top folder will be hidden and marked as system file - so you need to enable Show hidden files and folders and deactive Hide system files in your explorer. Kind regards Julian -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Migrate: copy or duplicate?
Hi all, My current configuration backs up to a NAS, and later though a migration job moves completed backups to tape for off-site storage. That puts up a dilemma: copy, or move? When I copy the backups to tape, I understand that only the original (NAS) version remains in the database, which would complicate things if ever a backup has to be restored from tape (find out which tape contains the files you are looking for, then scan that tape to get its catalog, etc.). When I move (migrate) them to tape, the backups on NAS are deleted at that time. Tapes are stored off-site, so I have to get in my car and go get them before I can restore anything. Isn't there a way to achieve a combination of both of these, so a copy would sort of duplicate the data in the database as well, and allow me to restore from the NAS or from tape, whichever is handy and available? It would be even better (saving space on the NAS) if I could use different retention periods for both copies. -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] SD for synology NAS?
Has anyone created the storage and/or file daemons for use on a Synology NAS running DSM 5.0? Some time ago I found directions on the web for compiling and installing bacula on DSM 4.0, but that required some NAS hacking (I regarded it as a sort of jailbreaking) that I'd rather not experiment with on a production system. -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] No files restored but disk space used?
Hello. This was just the tip I needed. You saved my day. Thanks. Regards, Florian S. Am 15.09.2014 um 10:51 schrieb Fahrer, Julian: Hi Floarian, 2014-09-15 10:38 GMT+02:00 Florian florian.spl...@web.de mailto:florian.spl...@web.de: Hello, everyone. I am doing final tests with my bacula setup and ran into some weird behavior. I set up an autochanger storage and am currently using the same device for backup and restore. I did a backup of the entire partition E:/ and browsed the files. Everything was there. Then I tried to restore the files to test-folder (avoiding overwrite). Bacula created the new Folder E:/Restore/ and the BAT told me the restore was compelted successfully after about 10 minutes. I opened the folder and it was empty though. Strangely enough, the emount of disk space in use on the harddrive increased. So far I don't have the slightest idea, what the problem may be... When I first tested bacula on a virtual machine, only backing up 2 small files, it worked perfectly fine. Regards, Florian S. When restoring an entire drive under windows, the created top folder will be hidden and marked as system file - so you need to enable Show hidden files and folders and deactive Hide system files in your explorer. Kind regards Julian -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Migrate: copy or duplicate?
Hello, 2014-09-15 12:43 GMT+02:00 Luc Van der Veken luc...@wimionline.com: Hi all, My current configuration backs up to a NAS, and later though a migration job moves completed backups to tape for off-site storage. That puts up a dilemma: copy, or move? When I copy the backups to tape, I understand that only the original (NAS) version remains in the database, which would complicate things if ever a backup has to be restored from tape (find out which tape contains the files you are looking for, then scan that tape to get its catalog, etc.). No. All copies goes to database as well, but they are indirectly available for restore and are promoted as a main backup only when original job expire. I could be wrong about it, but it was working as described last time I've check. best regards -- Radosław Korzeniewski rados...@korzeniewski.net -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Migrate: copy or duplicate?
From: Radosław Korzeniewski [mailto:rados...@korzeniewski.net] No. All copies goes to database as well, but they are indirectly available for restore and are promoted as a main backup only when original job expire. I could be wrong about it, but it was working as described last time I've check. Thanks, it looks like I misunderstood or misread that part of the docs. -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula writing in wrong volumes
Hi Ana, Em Sex, 2014-09-12 às 23:10 -0300, Ana Emília M. Arruda escreveu: ... You can try to put a Run Script directive on job definition like this: RunScript { RunsWhen = After RunsOnFailure = yes Command = /path/myscript.sh } And you could do some kind of shell script that could look for and delete the volume created and not used by your job. This way Bacula should create a new volume for the next job. Sorry I didn't had time for thinking about the script, but here is my idea for solving this situation. Thanks. Excelent idea Ana, in that way I can write a scrit that deletes the volume if the size is small (an empty one). I'll let my configuration of an volume per day with all backups from all services, that I posted before, to complete a cycle. If that works well, I'll keep that way, if not, I'll follow your suggestion. Best regards, Gean -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Switch Volume at end of month
Hi Florian, Maybe you could run an Admin Job for update volume status from append to used when the last day of the month is reached? Regards, Ana On Mon, Sep 15, 2014 at 3:40 AM, Florian florian.spl...@web.de wrote: Hello. I would like to use a Volume for the duration of one month and after the last backup of a month, I want to change the status of the Volume to Used or Full. I use the Volumes this long to have all Backup-Data from one monthly cycle in one file. I figured out how to check, if it is the last day of the month, but I am not sure how to automatically change the status of the specific Volume that has been used till then. Any suggestions are appreciated. Regards, Florian S. -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Switch Volume at end of month
Hello. Yes, I thought I will have to use the update command and using it manually is no problem, but I would like to automatically update the Volumes that are currently used for writing Backups at the end of the month. I will probably do this using an Admin Job, but I am unsure how to write a command for the update to happen. I don't have much experience with Unix scripting. Regards, Florian S. Am 15.09.2014 um 14:00 schrieb Ana Emília M. Arruda: Hi Florian, Maybe you could run an Admin Job for update volume status from append to used when the last day of the month is reached? Regards, Ana On Mon, Sep 15, 2014 at 3:40 AM, Florian florian.spl...@web.de mailto:florian.spl...@web.de wrote: Hello. I would like to use a Volume for the duration of one month and after the last backup of a month, I want to change the status of the Volume to Used or Full. I use the Volumes this long to have all Backup-Data from one monthly cycle in one file. I figured out how to check, if it is the last day of the month, but I am not sure how to automatically change the status of the specific Volume that has been used till then. Any suggestions are appreciated. Regards, Florian S. -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Wakeonlan in bacula
On 09/15/14 03:06, Florian wrote: Hello. I figured out the problem myself. I merely forgot to restart the director. Regards, Florian S. Hi Florian, Just a quick note to help you better administrate Bacula in the future: Instead of restarting the director after making changes to bacula-dir.conf you can do this: 1. From a shell prompt: bacula-dir -t -c /path/to/bacula-dir.conf This tests your bacula-dir.conf file (and any include files) for syntax. If this command returns nothing, then your syntax is correct. If there is a problem detected, it will inform you of the location where a problem was located. 2. If Step 1 is OK, start bconsole and issue the reload command. This will tell Bacula to reload it configuration file(s), and is (mostly) safe to do even while backups are running. Hope this helps Bill -- Bill Arlofski Reverse Polarity, LLC http://www.revpol.com/ -- Not responsible for anything below this line -- -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Version 7
Our backup server recently crashed (Ext4 corruption). I've rebuilt the server: Dual Xenon CPU's 12GB RAM 7x3GB SATA (1 additional for hotstandby) Raid-5 Adaptec 3905 with 512MB Ram and battery backup I was using Bacula 5.2 but would like to install the new version 7. However the repositories for Ubuntu 14.04 LTS seem to have version 5.2 still. Is there a PPA or other resource for installing the new version WITHOUT have to build it from source (that would be my last option)? Steve Hammond Venus, TX -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Wakeonlan in bacula
From: Bill Arlofski [mailto:waa-bac...@revpol.com] 1. From a shell prompt: bacula-dir -t -c /path/to/bacula-dir.conf The documentation seems to agree with you, but I once found another command somewhere (don't remember exactly where), with just the -v switch. So the reload script I created to check reload without having to enter the full details looks like this (there are three lines if wrapping should occur, # prepended to 2nd and 3rd line for safety): #!/bin/sh # bacula-dir -v /etc/bacula/bacula-dir.conf # [ $? -eq 0 ] service bacula-director reload || echo Config error found, NOT reloading. It seems to work as intended, with good as well as with bad config files. Is it really trying to start another instance of bacula-dir, or was I using some undocumented feature without realizing? When I add a -t switch, with or without -c, I get 4 or 5 lines of output about orphaned buffers. With only -v, I don't get those, but I *do* get the correct exit code to indicate OK or bad config. -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Wakeonlan in bacula
On 09/15/14 10:27, Luc Van der Veken wrote: From: Bill Arlofski [mailto:waa-bac...@revpol.com] 1. From a shell prompt: bacula-dir -t -c /path/to/bacula-dir.conf The documentation seems to agree with you, but I once found another command somewhere (don't remember exactly where), with just the -v switch. So the reload script I created to check reload without having to enter the full details looks like this (there are three lines if wrapping should occur, # prepended to 2nd and 3rd line for safety): #!/bin/sh # bacula-dir -v /etc/bacula/bacula-dir.conf # [ $? -eq 0 ] service bacula-director reload || echo Config error found, NOT reloading. It seems to work as intended, with good as well as with bad config files. Is it really trying to start another instance of bacula-dir, or was I using some undocumented feature without realizing? When I add a -t switch, with or without -c, I get 4 or 5 lines of output about orphaned buffers. With only -v, I don't get those, but I *do* get the correct exit code to indicate OK or bad config. Hi Luc I actually like the idea of a short shell script, as long as the Distributions service .. reload command issues a reload to bacula, and does not restart the bacula-dir daemon. Something to verify by checking the init script :) Other option, to avoid any distro-specific init file oddities is: (this will wrap, assume one line) [ $? -eq 0 ] echo reload | bconsole -c /path/to/bconsole.conf || echo Config error found, NOT reloading. Also, on v7.0.4, # bacula-dir -h shows that -v is verbose user messages so I do not see how that also, and only checks the config file for proper syntax - unless it is an undocumented feature. The -c is not necessary if your configs are in the default that the bacula binaries are compiled for. I keep mine in a non-standard directory, so I always specify -c, even when assisting others. Also, then I run: bacula-dir -v /path/to/bacula-dir.conf or bacula-dir -t -c /path/to/bacula-dir.conf or bacula-dir -v -t -c /path/to/bacula-dir.conf (with a known good bacula-dir.conf) Each gives no output (this is a v7.0.4 Bacula install on Gentoo Linux), so I am not sure why you would get the orphaned buffer messages you mentioned. Bill -- Bill Arlofski Reverse Polarity, LLC http://www.revpol.com/ -- Not responsible for anything below this line -- -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Switch Volume at end of month
Hello, I will probably do this using an Admin Job, but I am unsure how to write a command for the update to happen. I don't have much experience with Unix scripting. In order to update the status of a volume you can either pipe an update command through bconsole or access the database directly. Personally I find that going through bconsole, while technically cleaner, is extremely cumbersome (mainly because it is not that easy to find out exactly which volumes you need to update without doing a lot of output parsing and possibily even some queries), so I went the database way. Just to give you an idea, this is what I use in my setup in order to manually rotate the active volume in my pools at the beginning of every month: Job { Name = MarkDiskVolumeUsed JobDefs = DefaultJob Type = Admin FileSet = Catalog Schedule = sched.MF.00 RunBeforeJob = /usr/libexec/bacula/mark_disk_volumes_used db_name db_user db_passwd Priority = 1 } The sched.MF.00 schedule is such that this job is run at the *beginning* of the month, immediately before any backup jobs that will write to one of the affected pools. I find it easier this way than to run at the end of the month, as it is easier to predict the start time than the end time of backup jobs; however either can be done by choosing the right schedule and priority relative to your backup jobs. This is the mark_disk_volumes_used script: #!/bin/sh if [ $# -lt 3 ]; then echo Usage: $0 dbname dbuser dbpassword exit fi for pool in list_of_pools; do STATEMENT=update media set volstatus='Full' where poolid=(select poolid from pool where name='${pool}') and volstatus='Append' and voljobs 0 and volbytes 50; echo ${STATEMENT} | PGPASSWORD=$3 psql -U $2 $1 -f - done It will take the database connection parameters on the command line and will set every volume in 'Append' status within one of the pools listed in list_of_pools and with at least 5GB of written data to 'Full'. The filter on the volume size is there so that you can have more than one appendable volume within each pool (either because of preallocation or auto-recycling), but only the one which has actually been used for backups will be marked full; you may need to adjust the amount based upon your installation and backup schedule. The script above is for a postgreSQL database; if you are using something else you will have to update the next-to-last line with the appropriate command to execute a given query with the right user credentials. HTH, andrea Regards, Florian S. Am 15.09.2014 um 14:00 schrieb Ana Emília M. Arruda: Hi Florian, Maybe you could run an Admin Job for update volume status from append to used when the last day of the month is reached? Regards, Ana On Mon, Sep 15, 2014 at 3:40 AM, Florian florian.spl...@web.de mailto:florian.spl...@web.de wrote: Hello. I would like to use a Volume for the duration of one month and after the last backup of a month, I want to change the status of the Volume to Used or Full. I use the Volumes this long to have all Backup-Data from one monthly cycle in one file. I figured out how to check, if it is the last day of the month, but I am not sure how to automatically change the status of the specific Volume that has been used till then. Any suggestions are appreciated. Regards, Florian S. -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Switch Volume at end of month [Solved]
Hello. This is absolutely perfect. Thank you very much! Regards, Florian Am 15.09.2014 um 18:37 schrieb Andrea Conti: Hello, I will probably do this using an Admin Job, but I am unsure how to write a command for the update to happen. I don't have much experience with Unix scripting. In order to update the status of a volume you can either pipe an update command through bconsole or access the database directly. Personally I find that going through bconsole, while technically cleaner, is extremely cumbersome (mainly because it is not that easy to find out exactly which volumes you need to update without doing a lot of output parsing and possibily even some queries), so I went the database way. Just to give you an idea, this is what I use in my setup in order to manually rotate the active volume in my pools at the beginning of every month: Job { Name = MarkDiskVolumeUsed JobDefs = DefaultJob Type = Admin FileSet = Catalog Schedule = sched.MF.00 RunBeforeJob = /usr/libexec/bacula/mark_disk_volumes_used db_name db_user db_passwd Priority = 1 } The sched.MF.00 schedule is such that this job is run at the *beginning* of the month, immediately before any backup jobs that will write to one of the affected pools. I find it easier this way than to run at the end of the month, as it is easier to predict the start time than the end time of backup jobs; however either can be done by choosing the right schedule and priority relative to your backup jobs. This is the mark_disk_volumes_used script: #!/bin/sh if [ $# -lt 3 ]; then echo Usage: $0 dbname dbuser dbpassword exit fi for pool in list_of_pools; do STATEMENT=update media set volstatus='Full' where poolid=(select poolid from pool where name='${pool}') and volstatus='Append' and voljobs 0 and volbytes 50; echo ${STATEMENT} | PGPASSWORD=$3 psql -U $2 $1 -f - done It will take the database connection parameters on the command line and will set every volume in 'Append' status within one of the pools listed in list_of_pools and with at least 5GB of written data to 'Full'. The filter on the volume size is there so that you can have more than one appendable volume within each pool (either because of preallocation or auto-recycling), but only the one which has actually been used for backups will be marked full; you may need to adjust the amount based upon your installation and backup schedule. The script above is for a postgreSQL database; if you are using something else you will have to update the next-to-last line with the appropriate command to execute a given query with the right user credentials. HTH, andrea -- Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce. Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users