>>>>> On Thu, 16 Dec 2010 10:47:32 -0500, Bob Hetzel said:
>
> > From: Martin Simmons <martin AT lispworks DOT com>
>
> >>>>>> >>>>> On Wed, 15 Dec 2010 08:19:02 -0200, Rodrigo N de Castro
> >>>>>> >>>>> Fernandes said:
> >> >
> >> > I would like to know how to change the MediaId from a VolumeName.
> >> > Just for backup Media/Volume sort organization.
> >> >
> >> > Can somebody help me? Is it possible? Is it recommended?
> > It isn't recommended, but you could do it with some SQL commands if you are
> > very careful.
> >
> > Purge the volume first, otherwise you will need to update the jobmedia table
> > as well. You may need to adjust the SQL sequence that controls the
> > automatic
> > numbering of new volumes as well, if you new MediaId is higher. There may
> > be
> > other problems that I haven't though about...
> >
> > __Martin
>
> I'm not 100% sure what the original poster's goal was but in my case my
> goal was to change how bacula sorts when you do a 'list volumes'. It sorts
> by default by MediaId which is kinda unhelpful to those of us that use
> actual bar-coded tapes. The MediaId is generated when the volume is first
> inserted into the catalog, but if the autochanger picks up the tapes in the
> wrong order you're left with that odd sorting. I tried to update the
> tables directly for a while but eventually I decided it was too big a pain
> to wait for a tape to be Scratch (I presume you meant Prune not Purge, by
> the way).
No, I did mean Purge, becayse Prune might leave some jobmedia entries.
Maximum automatic destruction before manually wrecking the catalog with SQL
commands :-)
__Martin
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|