>> I am dealing with a corrupted database. isql, gfix or most commands
>> error out immediately saying "reached end of file". I get the
>> following output from gstat before it quits as well. Any chance I can
>> recover any data from this database ?
>>
>> Thanks for all your help.
>>
>>
>> Database header page information:
>> Flags 0
>> Checksum 12345
>> Generation 936636
>> Page size 4096
>> ODS version 10.1
>> Oldest transaction 936632
>> Oldest active 936633
>> Oldest snapshot 936633
>> Next transaction 936634
>> Bumped transaction 1
>> Sequence number 0
>> Next attachment ID 0
>> Implementation ID 16
>> Shadow count 0
>> Page buffers 0
>> Next header page 0
>> Database dialect 3
>> Creation date Apr 24, 2006 12:15:19
>> Attributes
>>
>> Variable header data:
>> *END*
>>
>>
>> Database file sequence:
>> File c:\test.fdb is the only file
>>
>> Database log page information:
>> Creation date
>> Log flags: 2
>> No write ahead log
>>
>> Next log page: 0
>>
>> Variable log data:
>> Control Point 1:
>> File name:
>> Partition offset: 0 Seqno: 0 Offset: 0
>> Control Point 2:
>> File name:
>> Partition offset: 0 Seqno: 0 Offset: 0
>> Current File:
>> File name:
>> Partition offset: 0 Seqno: 0 Offset: 0
>> *END*
>> I/O error for file "C:\TEST.FDB"
>> -Error while trying to read from file
>> -Reached the end of the file.
>>
>
>
> Burn the database file to a CD / DVD / some other write once media in
> case one of your experiments loses data. If gfix and iSQL die
> immediately, it is probably more serious than a bad record version,
> you may need to contact IBSurgeon.
>
> When everything settles back down, it is worth trying to determine how
> the database got corrupted, if it is hardware failure then it is just
> a matter of time before the next database goes.

One good reason for the corruption is that he is using the database with
forced writes off. Look at Ann's slide: ;-)
http://www.iblogmanager.com/download/misc/fbcon2005/page-0020.htm



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com