On Thursday 17 March 2005 04:58 am, Mike Winiberg wrote: > Hi, > > We recently had a problem which I haven't been able to fully recover from, > and would appreciate some advice about the best thing to do should > something like this happen again: [...] > However, when I next tried to run a backup, bacula made ten attempts to > create a volume with an existing name and then gave up saying that I should > use label to create a new volume for the backup to use. In other words, > although I'd managed to recreate the catalog, bacula was trying to start > volume numbering from the beginning again, and had not taken account of the > volumes it had already in the catalog. [...] > > Thanks for any help you can give. > > Mike Winiberg
I'm just beginning to explore the schema of the bacula database, but at first glance it would appear to be fairly easy to update the volume number to be used next by means of an sql update command. If I am not mistaken this is the table that keeps up with the next volume number: CREATE TABLE NextId ( id INTEGER UNSIGNED DEFAULT 0, TableName TEXT NOT NULL, PRIMARY KEY (TableName) ); (This is from the make_sqlite_tables script packaged included with the Debian bacula-director package, version 1.36.1-1.) Again, if I am not mistaken, then something along the lines of: update Nextld set id = 99 where TableName = "SomeTable"; would reset the next volume number. I know that Kern has already replied to your question, so if I'm really off-base, here, I hope he, or someone else more knowledgeable, will jump in & correct me. Cheers! cmr -- Debian 'Sarge': Registered Linux User #241964 ---- "More laws, less justice." -- Marcus Tullius Ciceroca, 42 BC -------- ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
