Re: [Bacula-users] force status full

2007-02-01 Thread Manuel Staechele
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

Re: [Bacula-users] force status full

2007-02-01 Thread Jose Molina
El jue, 01-02-2007 a las 09:04 +0100, Manuel Staechele escribió: 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,

Re: [Bacula-users] force status full

2007-02-01 Thread Arno Lehmann
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.

Re: [Bacula-users] force status full

2007-01-31 Thread Kern Sibbald
On Wednesday 31 January 2007 08:41, Manuel Staechele wrote: 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

Re: [Bacula-users] force status full

2007-01-31 Thread Manuel Staechele
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

Re: [Bacula-users] force status full

2007-01-31 Thread Ryan Novosielski
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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. Manuel

[Bacula-users] force status full

2007-01-30 Thread Manuel Staechele
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 =