Subject Re: Repair of damaged databases
Author Adam
--- In firebird-support@yahoogroups.com, Vahan Yoghoudjian
<vahan@p...> wrote:
> Hi Group
>
> One of our prospects who is buying our software called me
informing that
> his old data (FB 1.5) got damaged. According to the previous posts
posted
> here in the group I can assume that the damage was due to an electrical
> shutdown, knowing that it happens a lot with them because they overload
> their power supplies, and it even happened during one of my visits
there...

Firstly, unless the hard drive is damaged in the process, or they have
done something naughty like turning off forced writes, Firebird should
recover fine from a loss of power, although I would still get the
power situation rectified because it can be frustrating to lose work
when the DB connection dies.

I do not know the expertise of your prospect, and whether "got
damaged" means that the db is corrupt, or whether they have deleted an
important piece of data and now the app doesn't run properly.

Often ameteur users are the most dangerous, ie those who are not
respectfully afraid of mucking around with add remove programs or
playing around with configuration settings and installing firewalls etc.

Anyway try running gfix on it to see if there are any problems
(-validate and -mend are the things of interest).

This may well fix it. Otherwise, it is your call whether to ditch the
fdb. Even if it is damaged, there are services that can recover most
of the data, but it wont be cheap, but whether this is worth it really
depends on how critical the data is. Given the backup is 3 weeks old,
I am hoping that it is not at all critical.

Adam