On Thu, May 22, 2008 at 11:27 AM, Alan Brown <ajb2 AT mssl.ucl.ac DOT uk> wrote:
>
> 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.
>
I would restore the Friday database backup and then use bscan on the
new media. I assume there were not 60 tapes written since friday?

John

-------------------------------------------------------------------------
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