On Mon, Dec 8, 2008 at 4:13 PM, Lukasz Szybalski <[EMAIL PROTECTED]> wrote:
> On Mon, Dec 8, 2008 at 3:01 PM, Robert Du Gaue <[EMAIL PROTECTED]> wrote:
>>
>>
>> 2. Tomorrow if the full backup succeeded how do I get rid of the old
>> volume so that bacula knows about it and doesn't try to access it
>> later.
>>
>>
>>
>> prune
>> The Prune command allows you to safely remove expired database
>> records from Jobs and Volumes. This command works only on the
>> Catalog database and does not affect data written to Volumes. In all
>> cases, the Prune command applies a retention period to the specified
>> records. You can Prune expired File entries from Job records; you can
>> Prune expired Job records from the database, and you can Prune both
>> expired Job and File records from specified Volumes.
>> prune files—jobs—volume client=<client-name> volume=<volumename>
>> For a Volume to be pruned, the VolStatus must be Full, Used, or
>> Append, otherwise the pruning will not take place.
>>
>> purge
>>
>> The Purge command will delete associated Catalog database records
>> from Jobs and Volumes without considering the retention period.
>> Purge works only on the Catalog database and does not affect data
>> written to Volumes. This command can be dangerous because you can
>> delete catalog records associated with current backups of files, and we
>> recommend that you do not use it unless you know what you are doing.
>> The permitted forms of purge are:
>> purge files jobid=<jobid>—job=<job-name>—client=<clientname>
>> purge jobs client=<client-name> (of all jobs)
>> purge volume—volume=<vol-name> (of all jobs)
>> For the purge command to work on Volume Catalog database records
>> the VolStatus must be Append, Full, Used, or Error.
>> The actual data written to the Volume will be unaffected by this command.
>>
>> Afterwards, delete the actual physical file if you need to recover the disk
>> space.
>>
>> -------------------------------
>
> I've called the new pool NewDefault
> but
>
> I've added a new pool to a director file, and changed the sd settings
> to use the new pool but when I restart bacula I get :
> [EMAIL PROTECTED]:/home/bacula/backups$ sudo /etc/init.d/bacula-director
> restart
> Password:
> Restarting Bacula Director: 08-Dec 16:07 bacula-dir: Fatal error:
> sql_create.c:196 sql_create.c:196 insert INSERT INTO Pool
> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat)
> VALUES
> ('NewDefault',0,20,0,1,1,1,1,2678400,0,0,0,26843545600,'Backup',0,''Volumes'')
> failed:
> You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'Volumes'')' at line 1
> bacula-dir.
>
No quotes on the label name.
Is this all I need to do:
# Default pool definition
Pool {
Name = NewDefault
Pool Type = Backup
Recycle = yes # Bacula can automatically recycle Volumes
AutoPrune = yes # Prune expired volumes
Volume Retention = 31 days # one year
Accept Any Volume = yes # write on any volume in the pool
Maximum Volumes = 20
Maximum Volume Bytes = 26843545600 #25 GB
Label Format = Volumes
}
???
Thanks,
Lucas
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
