On Thu, Apr 05, 2012 at 12:47:02PM +0200, Dennis Hoppe wrote:

> maybe you could send me your config files? Which distribution and
> version are you using?
> 

Hello Dennis, 

I'm running Bacula 5.2.6 compiled from source on CentOS 6.2 (64bit)
with a MySQL backend. 

Here's the relevant config for the pool I'm copying to tape: 

Pool {
  Name = Online_full
  Pool Type = Backup
  Storage = FileStorage_full
  Recycle = yes
  AutoPrune = yes   
  Volume Retention = 180 days
  Purge Oldest Volume = yes
  Recycle  Oldest Volume = yes
  Maximum Volumes = 28
  Maximum Volume Bytes = 195G
  Label Format ="full-"
  Next  Pool = "Offline"
}

Pool {
  Storage = lto4
  Name = Offline
  Pool Type = Backup
  Recycle = yes
  AutoPrune = yes
  Volume Retention = 365 days
  Purge Oldest Volume = yes
  Recycle  Oldest Volume = yes
  Maximum Volumes = 21
  Label Format ="Offline-"
}

and here's my copy job definition for the full backups completed
within the last 7 days: 

Job {
  Name = "copy-full"
  Type = Copy
  Level = Full
  Priority = 15  
  Pool = Online_full
  Messages = Standard
  Maximum Concurrent Jobs = 2
  Schedule = Copy-full # runs once a week for now 
  Selection Type = SQLQuery
  Selection Pattern = "                                                        
    SELECT jobid                                                                
    FROM Job                                                                    
    WHERE PoolId = 4                                                            
    AND type = 'B'                                                              
    AND level = 'F'                                                             
    AND jobstatus = 'T'                                                         
    AND EndTime >= SUBDATE(NOW(), INTERVAL 7 DAY)                               
    GROUP BY Name;"

}

I'm restricting the copy jobs artificially for now because we have run
the full pool for quite a while and I've only recently started messing
around with copy jobs, so for this pool I only want jobs completed in
the last week to be copied over to tape. I bet there's a more clever
way to implement this, but your SQLQuery thingy turned out to be a
godsend for the task at hand, although it could probably done with
AllowDuplicateSomething or other in a more supported and elegant
fashion.

All the best, Uwe 



-- 
NIONEX --- Ein Unternehmen der Bertelsmann AG



------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users