Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Error 9217 when restoring backup
Fri, Jun 9 2006 10:49 PMPermanent Link

"Bill Root"
I have a customer who lost a DBISAM 4 database when the computer crashed=
..

He has a recent backup created with the TDBISAMDatabase.Backup function,=
 =

but when we restore with it, we get error 9217.  The same error is  =

reported when I try to restore it with DbSys 4.24.  Here is the log:

Restore of database D:\Business\Ascendis Software\Dev\Taxi_Booker\Win32\=
DB  =

started at 06/09/2006 10:22:42 PM...
Backup file C:\[...]\back up.dbbackup read...
Starting restore of table Bookings...
Restoring table Bookings (data) 816696 bytes...
Restoring table Bookings (indexes) 78336 bytes...
Restoring table Bookings (BLOBs) 636928 bytes...
Restore of table Bookings completed...
Error during restore of database D:\[...]\DB - DBISAM Engine Error # 921=
7  =

Error reading from the table or backup file 'C:\[...]\back up.dbbackup'.=
...

One table, Bookings, is at least partially restored.  (It could be  =

completely restored; I can't tell.)  Another table is not restored at  =

all.  Is there any way to restore the other table(s)?

Also, what would have caused the backup to apparently become bad?

I don't know which version of DBISAM created the backup, but the exe is =
a  =

year old, so it was something available in June 2005.

Finest regards,
Bill Root
Sat, Jun 10 2006 7:33 PMPermanent Link

"Bill Root"
I did some checking into CVS and it looks like version 4.21 was used by =
=

the program that created the backup file, if that helps.  I don't know  =

which build number, but the following "Serious Problems" were fixed in t=
he  =

release:
   2051, 2056, 2061, 2065, 2068

(I got this info from the "readme.htm" included in the release.  If  =

there's a file in the DBISAM standard source release that includes the  =

build number, tell me what it is and I can check it.)

Finest regards,
Bill Root


On Fri, 09 Jun 2006 22:46:28 -0400, Bill Root <BillRootATascendisDOTcom>=
 =

wrote:

> I have a customer who lost a DBISAM 4 database when the computer crash=
ed.
>
> He has a recent backup created with the TDBISAMDatabase.Backup functio=
n,  =

> but when we restore with it, we get error 9217.  The same error is  =

> reported when I try to restore it with DbSys 4.24.  Here is the log:
>
> Restore of database D:\Business\Ascendis  =

> Software\Dev\Taxi_Booker\Win32\DB started at 06/09/2006 10:22:42 PM...=

> Backup file C:\[...]\back up.dbbackup read...
> Starting restore of table Bookings...
> Restoring table Bookings (data) 816696 bytes...
> Restoring table Bookings (indexes) 78336 bytes...
> Restoring table Bookings (BLOBs) 636928 bytes...
> Restore of table Bookings completed...
> Error during restore of database D:\[...]\DB - DBISAM Engine Error #  =

> 9217 Error reading from the table or backup file 'C:\[...]\back  =

> up.dbbackup'...
>
> One table, Bookings, is at least partially restored.  (It could be  =

> completely restored; I can't tell.)  Another table is not restored at =
=

> all.  Is there any way to restore the other table(s)?
>
> Also, what would have caused the backup to apparently become bad?
>
> I don't know which version of DBISAM created the backup, but the exe i=
s  =

> a year old, so it was something available in June 2005.
>
> Finest regards,
> Bill Root
Mon, Jun 12 2006 11:30 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Bill,

<< He has a recent backup created with the TDBISAMDatabase.Backup function,
but when we restore with it, we get error 9217.  The same error is reported
when I try to restore it with DbSys 4.24.  Here is the log:

Restore of database D:\Business\Ascendis Software\Dev\Taxi_Booker\Win32\DB
started at 06/09/2006 10:22:42 PM...
Backup file C:\[...]\back up.dbbackup read...
Starting restore of table Bookings...
Restoring table Bookings (data) 816696 bytes...
Restoring table Bookings (indexes) 78336 bytes...
Restoring table Bookings (BLOBs) 636928 bytes...
Restore of table Bookings completed...
Error during restore of database D:\[...]\DB - DBISAM Engine Error # 9217
Error reading from the table or backup file 'C:\[...]\back up.dbbackup'...

One table, Bookings, is at least partially restored.  (It could be
completely restored; I can't tell.)  Another table is not restored at
all.  Is there any way to restore the other table(s)? >>

If you send me the backup, I can take a look and see if the backup file is
truncated or at least tell you what is wrong with it.

<< Also, what would have caused the backup to apparently become bad? >>

Same thing that could cause any file issues - corruption or truncation due
to file system issues such as lack of disk space, improper shutdowns, etc.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Jun 12 2006 12:42 PMPermanent Link

"Bill Root"
On Mon, 12 Jun 2006 11:30:47 -0400, Tim Young [Elevate Software]  =

<timyoung@elevatesoft.com> wrote:

> Bill,
>
> If you send me the backup, I can take a look and see if the backup fil=
e  =

> is
> truncated or at least tell you what is wrong with it.

Thank you, it's on its way via email.

Finest regards,
Bill Root
Image