Urgent: Fix a corrupt firebird table

I beleive the table HR_WAGE_BOOK is corrupt because when I use this command "select * from hr_wage_book" or "delete * from HR_Wage_BOOK", I receive this error message:

Error Message:
----------------------------------------
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
database file appears corrupt ().
wrong page type.
page 49913 is of wrong type (expected 7, found 5).
----------------------------------------

I still can fetch some records of this table.
This is the database:

http://www.4shared.com/file/110736217/f401d1f5/SSP_HRM_DB_VanTaiBiaSG.html

And the version of firebird is 2.0

please attempt to do a backup & restort (to a different nameed file) if this has errors try using gfix

When I try backing up the database, I receive this error:
------------------------------------------------------------
Unsuccessful excution caused by a system error that precludes successful excution of subsequent statements.
Database file appears corrupt ().
wrong page type.
Page 49913 is of wrong type (expected 7, found 5).
gds_$receive failed.
-------------------------------------------------------------
So the backing up failed :(.

so what version of firebird

what happens if you use gfix

ok I see you are using firebird 2.0, but there should be 3 digits 2.0.?

I use Firebird-2.0.3.12981.

what happens when you run gfix against this database,

I'm very new to firebird. So I don't know how/where to run gfix? What do I need to run gfix?

gfix is a utility program like gbak only it's job is to try and fix problems like yours

do you know why the corruption occurred, obviously this also needs to be sorted out

My company buys a program that use this database. It seems when the program runs a command that use/update a lot of tables, the database corrupts. Could you give me the link to download gfix/gbak? Is it free?

OK. I found gfix in "C:\Program Files\Firebird\Firebird_2_0\bin" :D. But when I run command
C:\Program Files\Firebird\Firebird_2_0\bin>gfix -validate "C:\Program Files\SSP\HRM20\SSP_HRM_DB_VanTaiBiaSG.GDB" -user sysdba -password masterkey, there's no return message! Is the syntax right?

This is the result when I run gfix:
------------------------------------------------------------------
C:\Program Files\Firebird\Firebird_2_0\bin>gfix.exe -v -full -user sysdba -pass
masterkey "C:\Program Files\SSP\HRM20\SSP_HRM_DB_VanTaiBiaSG.GDB"
Summary of validation errors
        Number of index page errors     : 257
        Number of database page errors  : 10115
------------------------------------------------------------------
How to fix it now?

And the result of gfix with repairing:
------------------------------------------------------
C:\Program Files\Firebird\Firebird_2_0\bin>gfix.exe -mend -full -ignore -user sy
sdba -pass masterkey "C:\Program Files\SSP\HRM20\SSP_HRM_DB_VanTaiBiaSG.GDB"
Summary of validation errors
        Number of index page errors     : 257
        Number of database page errors  : 10115
------------------------------------------------------
Nothing fixed :((. It can detect errors but it cannot fix it.

having used -mend you should now be able to take a valid backup, hopefully

there is no good reason for the corruption to happen in the way you describe, it is possible, although difficult, to corrupt a database from the client program. common normal causes are things like taking a file copy while it's in use or bad ram

Everything is possible to corrupt the database file. But the important thing is fix it. gfix can't fix. So is there other ways?

you may be able to do a backup & restore now, please try

if not you can either copy the data a table at a time to another database and then use that to replace the original (losing some data that cannot be extracted) or pay www.ibsurgeon.com who can probably fix it

try to contact SSP to be supported!

or contact me if you cannot solve it!

I uploaded the database at http://www.4shared.com/file/110736217/f401d1f5/SSP_HRM_DB_VanTaiBiaSG.html. I try backing up the database but the backup process failed. Please download and try if there's any program can fix it. The data in the corrupt table isn't important. It seems you know somenone in SSP :D?

Your database can recovery well but I cannot show you the procedure here.
contact me if you want.