Re: [Bacula-users] force status full
I would not recommend doing this, and instead limiting media use by VolumeUseDuration or MaximumVolumeJobs. Homegrown queries are probably not the easiest things to follow in the future, and there is really no need for them, I wouldn't think. we tried VolumeUseDuration but the result was that the status of media switch to used but will not re used, so did not purge or prune the volume that we can a next job can use the volume again. so my question did you sucessfull test the VolumeUseDuration your self or only in theory? we tried this a few month ago so it can be that it work in newer bacula versions? Manuel Staechele wrote: i want every media LastWritten 7 days ago to go in full status. because if the media is append, it will not automatic pruned i have wrote a little sql query to do the job, but want ask if there is a better, than execute the sql query every day. I'll let others on this list answer your question, but in your SQL below, I see no reason to change a Used status to Full. sql query: UPDATE Media SET VolStatus = 'Full' WHERE (VolStatus = 'Append' or VolStatus = 'Used') AND LastWritten NOW() - interval 7 DAY yes ok, my failure i was not sure about status Used. so i want to update Media Table after Job BackupCatalog. Is there any other solution for what i want? thanks in advance manuel - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - -- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III |$| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFwL0xmb+gadEcsb4RAu3fAJwNTMQck3t1OTpfB9eY+5ymZz//OwCeKGXX XNJqvllSoOmdgZ166IMtLas= =dtRf -END PGP SIGNATURE- -- Mit freundlichen Grüssen Manuel Stächele Dr. Levante GmbH Co.KG, Netzwerkbetreuung und Software-Entwicklung Hauptstrasse 46, 79639 Grenzach - Wyhlen, Deutschland Tel: +49 7624 9167-10 Fax: +49 7624 80562 Email: [EMAIL PROTECTED] oder [EMAIL PROTECTED] - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] force status full
i want every media LastWritten 7 days ago to go in full status. because if the media is append, it will not automatic pruned i have wrote a little sql query to do the job, but want ask if there is a better, than execute the sql query every day. I'll let others on this list answer your question, but in your SQL below, I see no reason to change a Used status to Full. sql query: UPDATE Media SET VolStatus = 'Full' WHERE (VolStatus = 'Append' or VolStatus = 'Used') AND LastWritten NOW() - interval 7 DAY yes ok, my failure i was not sure about status Used. so i want to update Media Table after Job BackupCatalog. Is there any other solution for what i want? thanks in advance manuel - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] force status full
hi, i want every media LastWritten 7 days ago to go in full status. because if the media is append, it will not automatic pruned i have wrote a little sql query to do the job, but want ask if there is a better, than execute the sql query every day. sql query: UPDATE Media SET VolStatus = 'Full' WHERE (VolStatus = 'Append' or VolStatus = 'Used') AND LastWritten NOW() - interval 7 DAY thanks for idees. greetings manuel staechele -- Mit freundlichen Grüssen Manuel Stächele Dr. Levante GmbH Co.KG, Netzwerkbetreuung und Software-Entwicklung Hauptstrasse 46, 79639 Grenzach - Wyhlen, Deutschland Tel: +49 7624 9167-10 Fax: +49 7624 80562 Email: [EMAIL PROTECTED] oder [EMAIL PROTECTED] - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] stop a running job and change the tape
hi list, is there a possibility to sotp a job, change the tape and then resume the job. so i dont want cancel the job but say job stop or wait i need to change the tape... reason for asking, some times the tape is nearly full but i have evening and so i want to change the tape with a new one so bacula can work over night. thanks for any help greetings manuel - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] find out the volume name in drive
hello, how can i get the name of the volume which is in the drive without mounting the volume? is there a command in the bconsole etc.? thanks greetings manuel - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] find out the volume name in drive
Ralf Gross schrieb: Manuel Staechele said: how can i get the name of the volume which is in the drive without mounting the volume? is there a command in the bconsole etc.? You can use the mtx-changer command for that. i have no autochanger... is there a similar command for a tape drive? tanks greetings manuel - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] find out the volume name in drive
Michel Meyers schrieb: Manuel Staechele wrote: hello, how can i get the name of the volume which is in the drive without mounting the volume? is there a command in the bconsole etc.? btape can read labels with the 'readlabel' command as far as I know. I'm not sure you'll be able to use btape though if the SD is up. yes it works: echo readlabel | btape /dev/nst0 -c /etc/bacula/bacula-sd.conf many thanks ! greetings manuel - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] list nextvol
Hello, one question the command list nextvol job=NAME works fine for me with bconsle version Version: 1.36.3 (22 April 2005) but in version: Version: 1.38.11 (28 June 2006) the nextvol job=NAME command shows the same output as list job=NAME and additional a line with the nextvol information on top. so for a bash script that is not wath i want. i want a single line such as in Version 1.36 ... i can not find any futher informations about this problem. thanks for your idees greetins manuel - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Filesystem change prohibited. Will not descend into
Hello List, i do not understand the message: server-fd: Filesystem change prohibited. Will not descend into /home did bacula save this directory or not? It came only this message, the job it self is OK without warnings, so i think it doesn't matter. If bacula did not save the directory, how can i say to do so? thanks for answer. greetings, manuel - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Performance problems
Hello, i want restore a simple file from a FULL job which is not that big. and it took 10 hours to build the directory-tree. job informations: Type | Level | JobFiles | JobBytes| JobStatus | B| F | 913,065 | 17,818,106,395 | T -- i have already checked if there are all recomented indexes in the databases. but they are all there. database: mysql bacula-director and bacula-sd are not on the same server - are there any hints to improve this situation? thanks for any suggestions and ideas! greetings from Grenzach in Germany manuel staechele - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users