Hi, On 2/1/2007 9:04 AM, Manuel Staechele wrote: >>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?
I can confirm that VolumeUseDuration dos work - I do have setups where I use it, and with the number of volumes limited this has the wanted effect, i.e. the volumes are recycled after their retention period is over. > we tried this a few month ago so it can be that it work in newer bacula > versions? Certainly since 1.36.something this does work, IIRC. Most probably your volume parameters are not set correctly, or your volumes need a shorter retention time - keep in mind that the retention period starts after the last write to a volme, not after it's current contents was started. If, for example, you want to reuse volumes after one day and your job runs less than an hour, a retention time of 23 hours is correct, but 1 day would not work. VolumeUseDuration should be set similarly. In the setups I manage, IIRC I have a duration of 12 hours (where about two hours would be enough, but this allows me to intervene in the morning if the nights backup has any problem). Arno > >>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.php&p=sourceforge&CID=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----- >> > > -- IT-Service Lehmann [EMAIL PROTECTED] Arno Lehmann http://www.its-lehmann.de ------------------------------------------------------------------------- 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=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
