Bacula-users

Re: [Bacula-users] volume management on a storage File

2008-12-08 17:15:42
Subject: Re: [Bacula-users] volume management on a storage File
From: "Lukasz Szybalski" <szybalski AT gmail DOT com>
To: "Robert Du Gaue" <rdugaue AT calweb DOT com>
Date: Mon, 8 Dec 2008 16:13:10 -0600
On Mon, Dec 8, 2008 at 3:01 PM, Robert Du Gaue <rdugaue AT calweb DOT com> 
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 :
me@someserver:/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.

Ideas?

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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
<Prev in Thread] Current Thread [Next in Thread>