Lester,

As one who also still runs IB5.6 (on SCO) - this is scary ...
Is there any archiving process running ?
Does a verbose 'gbak -b -v' show that any records are written ?
The backup that happens from the batch file ... does it produce an
historical log ?
Does it also restore ? If it restores as well - I would look at that -
perhaps along the line one of the restores failed ?

bill


Lester Caine wrote:

> One of the few sites that I still have running IB5.6 ( because they
> won't pay for an update ;) ) has had a hiccup which I can't understand.
>
> They do not have access to any SQL tools, like IB_SQL, so they can't
> 'fiddle', backup happens from a batch file, and SHOULD have left me with
> a couple of back issues, but for some reason the database is empty. The
> metadata is correct, just all tables blank, yet the file size is still
> 79Mb.
>
> Backup and restore produces a 700k blank database, but anybody got any
> idea how the contents could be wiped? I could understand a backup
> metadata only, but then size would change. The only other thing would be
> 'DELETE FROM xxx' for each table - which in theory they can't do. So any
> other thoughts?
>
> I'm not too desperate in this, although there is 6 months of data in
> theory missing between the last engineers visit and now, but since they
> have not been using the system properly I'm happy to say - well if you
> had updated ... but it would be nice to fill the gap as it could help
> win another order.
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
>
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
> <http://us.ard.yahoo.com/SIG=129m0g96n/M=295196.4901138.6071305.3001176/D=groups/S=1705115386:HM/EXP=1091118706/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com>
>
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>