One of my smarter customers has managed to end a process (via task
manager) that was in the middle of optimizing a table, containing a
huge blob file. He mailed me complaining that alot of data seems to
have disappeared after his stunt.

The bad news is that he restarted the application after ending it,
which caused it to overwrite the .bbk, .dbk, and .ibk backups again
with the bad files, since it restarted the optimizing process.

I know the man himself is not to be helped, but can any of the data be
recovered?

Many thanks.


PS: using 3.30

--

Dominique,

I don't know how to recover files corrupted in that way.

This situation could force you to think about procedure for daily backups
incorporated in your application that makes every time new backup. New
backup should overwrite the oldest in a list of, let say, 10 backups. In
that case the user could restore any backup from the list.

Iztok Lajovic


"Dominique Willems" <dominique.willems@gmail.com> je napisal v sporocilo
news:15D6E8CE-EE1C-48E4-A1B2-7055B60F4745@news.elevatesoft.com ...
> One of my smarter customers has managed to end a process (via task
> manager) that was in the middle of optimizing a table, containing a
> huge blob file. He mailed me complaining that alot of data seems to
> have disappeared after his stunt.
>
> The bad news is that he restarted the application after ending it,
> which caused it to overwrite the .bbk, .dbk, and .ibk backups again
> with the bad files, since it restarted the optimizing process.
>
> I know the man himself is not to be helped, but can any of the data be
> recovered?
>
> Many thanks.
>
>
> PS: using 3.30
>
> --
>

Iztok Lajovic wrote:
> This situation could force you to think about procedure for daily
> backups incorporated in your application that makes every time new
> backup. New backup should overwrite the oldest in a list of, let say,
> 10 backups. In that case the user could restore any backup from the
> list.

That's been built-in for over a decade, but he has to click the button.


--

Dom,

<< I know the man himself is not to be helped, but can any of the data be
recovered? >>

Perhaps using a disk-editing tool, but that's about it.  Once a file is
overwritten, then it's hard to get the data back.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
> Perhaps using a disk-editing tool, but that's about it.  Once a file
> is overwritten, then it's hard to get the data back.

I took a look at his table, deleted a few odd rows, applied a repair,
then an optimize, and all is dandy.

That's DBISAM for you. Never a bit lost in its entire career.

--

Dom,

<< I took a look at his table, deleted a few odd rows, applied a repair,
then an optimize, and all is dandy. >.

Wow, cool.  I'm glad that you were able to recover everything okay.

<< That's DBISAM for you. Never a bit lost in its entire career. >>

That's always a good thing, but in this case it was the developer that saved
the day.

--
Tim Young
Elevate Software
www.elevatesoft.com