Firebird - Recover Database

Asked

Viewed 1,636 times

1

I am trying to recover a corrupted database using Firebird’s own utilities. When logging in to the bank you have the following error:

database file appears Corrupt ()

bad checksum

checksum error on database page 21708

I tried some procedures by gfix and gbak :

gfix -v -f -i DADOS
gfix -m -i DADOS
gbak -g -b -z -l -v DADOS

I was unsuccessful in any case.

I just had this return of different :

Wrong page type

page 21708 is of Wrong type (expected 3, found 69)

Has anyone ever tried to recover banks with this kind of mistake? I use Firebird 2.5

database firebird

1 answer

1

So come on, first recommend to check again if it returns any errors... use this command to know, being inside the folder with the cmd opened in it.

gfix -v -full caminho_da_base -user nome_usuario -pass senha_usuário

Example

gfix -v -full C:\Sistema\banco.fdb -user SYSDBA -pass masterkey

If error returns, which is very likely, run this code to try to repair/ recover

gfix -m -i caminho_da_base -user nome_usuario -pass senha_usuário

Example

gfix -mend -full -ignore C:\Sistema\banco.fdb -user SYSDBA -pass masterkey

If that doesn’t work, log in link that has something more complete

  • Friend, these are the commands I’ve tried. Even by this link you passed. Thank you

  • https://www.devmedia.com.br/forum/reparar-bd-firebird-corrompido/59054

  • See if this helps

  • I found a similar error, but there is no success in restoring.

  • https://edn.embarcadero.com/article/25136

  • I did the procedures of the links but always get the same result. I thank for the effort, but I believe that it will not be possible to recover this bank. I read something about changing the value of the page with error by a hex editor, but I could not locate the record with error.

  • Didn’t you ever make a bakcup that you can recover? because apparently this error/ corruption has no way back :(

  • I have a backup but a little old. It was due to hard drive failure that suffered a fall.

Show 3 more comments

Browser other questions tagged database firebird

You are not signed in. Login or sign up in order to post.