On 12/15/2010 08:29 PM, Martin Simmons wrote: >>>>>> 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 >
If the name can be changed, bcopy could be an option oldname -> newname and so new id but I, like Martin said, wouldn't touch the id in the database. -- Bruno Friedmann (irc:tigerfoot) Ioda-Net Sàrl www.ioda-net.ch openSUSE Member User www.ioda.net/r/osu Blog www.ioda.net/r/blog fsfe fellowship www.fsfe.org GPG KEY : D5C9B751C4653227 vcard : http://it.ioda-net.ch/ioda-net.vcf ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users