Bacula-users

[Bacula-users] Database woes

2008-05-22 11:28:39
Subject: [Bacula-users] Database woes
From: Alan Brown <ajb2 AT mssl.ucl.ac DOT uk>
To: bacula-users AT lists.sourceforge DOT net
Date: Thu, 22 May 2008 16:27:24 +0100 (BST)
For some reason Bacula aged out ALL my old JobIds from the database on
Friday night. This happened after a database backup, but before any new
backups were made.

I have a friday's backup sql, however there have been several backups made
over the weekend and I've generated a "new" backup.sql which contains all
jobs run in that period.

Is there any easy/practical way to merge the 2 sql backups in order to
regain all the old records AND keep the new ones (in particular updating
status of tapes so I know which have been written to)?

I've been working on this on and off since monday morning, but am hoping
someone has a fast way out for this.

Bscan works, but is incredibly slow when there are 60 tapes to consider -
right now I'm not entirely sure which ones have been relablled/reused over
the weekend.

AB

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
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>