Re: [Bacula-users] SQL query

2010-01-14 Thread David Dumortier
Hi, Martin Simmons a écrit : >>>>>> On Wed, 13 Jan 2010 14:18:18 +0100, David Dumortier said: >> Importance: Normal >> >> Hi all, >> >> I try to query MySQL to obtain all the date of backup for a file. >> I used this but have only the las

[Bacula-users] SQL query

2010-01-13 Thread David Dumortier
Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId AND Job.JobId=File.JobId AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId AND Client.Name='%1' AND Filename.Name='%2' ORDER BY Path.Path; Any help appreciated Best regards

[Bacula-users] [Half-Solved] Retention on SD File

2009-11-27 Thread David Dumortier
line, I changed it to 25G. I'll see if it's ok, and I have good hope it is. [...] > -- > John M. Drescher Thank you John, you make my day ! Best regards, -- David Dumortier -- Let Crystal Reports handl

Re: [Bacula-users] [Solved] Re: Retention on SD File

2009-11-27 Thread David Dumortier
Hi, David Dumortier a écrit : > Hi, > > John Drescher a écrit : [...] > It's ok for the change of volume, I will wait tomorow to see if the > automatic rotation is ok. I had to force the status Full to my volume after the Maximum Volume Bytes >>> >>> Se

[Bacula-users] [Solved] Re: Retention on SD File

2009-11-26 Thread David Dumortier
? > > You can mark volume 4 full or used by the update volume status command > to force the retention period to begin. It's ok for the change of volume, I will wait tomorow to see if the automatic rotation is ok. >> >> Second question, have I to create the 30 volumes

Re: [Bacula-users] Retention on SD File

2009-11-25 Thread David Dumortier
John Drescher a écrit : > On Wed, Nov 25, 2009 at 4:07 AM, David Dumortier > wrote: >> Hi all, >> >> David Dumortier a écrit : >>> Hello, >>> >>> John Drescher a écrit : >>>> On Mon, Nov 23, 2009 at 4:16 AM, David Dumortier >>

Re: [Bacula-users] Retention on SD File

2009-11-25 Thread David Dumortier
Hi all, David Dumortier a écrit : > Hello, > > John Drescher a écrit : >> On Mon, Nov 23, 2009 at 4:16 AM, David Dumortier >> wrote: >>> >>> My bacula-sd.conf : >>> Device { >>>  Name = stockage >>>  Media Type =

Re: [Bacula-users] Retention on SD File

2009-11-23 Thread David Dumortier
Hello, John Drescher a écrit : > On Mon, Nov 23, 2009 at 4:16 AM, David Dumortier > wrote: >> >> My bacula-sd.conf : >> Device { >>  Name = stockage >>  Media Type = File >>  Archive Device = /mnt/sauvegardes >>  LabelMedia = yes;                

[Bacula-users] Retention on SD File

2009-11-23 Thread David Dumortier
{ Name = myhost Address = myIP FDPort = 9102 Catalog = MyCatalog Password = "*" File Retention = 7 days Job Retention = 7 days AutoPrune = yes # Prune expired Jobs/Files } Best regards, -- David