Tag Archives: gfix

Recuperar base de dados corrompida

gFix:

1º – gfix -v -full c:\banco\corrompida.fdb -USER SYSDBA -pass masterkey
2º – gfix -mend c:\banco\corrompida.fdb -USER SYSDBA -pass masterkey

-v :v[erbose]
-full :validate record fragments, o mesmo que
-mend : prepare corrupt database for backup

gBak:

3º – GBAK -backup -V -ignore -garbage -limbo C:\banco\corrompida.fdb C:\banco\corrompida.gBK -USER SYSDBA -pass masterkey
4º – GBAK -c -v -z C:\banco\corrompida.gbk C:\banco\corrompida.fdb -USER SYSDBA -pass masterkey

-backup ou -b: b[ackup_database]. Back up. This switch is optional.
-limbo ou -l : Ignores limbo transactions while backing up
-ignore : -ig[nore] Ignores checksum errors while backing up
-garbage :-g[arbage collect] Does not perform garbage collection (sweeping) during backup
-limbo : -l[imbo] Ignores limbo transactions while backing up
-z :Show GBAK version and server version
-c : c[reate_database]Restore to a new database (the target database file MUST NOT exist)

Links:

http://www.destructor.de/firebird/gbak.htm

http://mail.firebase.com.br/pipermail/lista_firebase.com.br/2005-June/014097.html