![]() use GFIX -mend to prepare corrupt database for backup.If problem is not too serious, you can try to backup the broken db and restore under a new name: use GFIX with -v and -f to do full validation.use GFIX with -v option to validate the database file.make a copy of database file (or two copies) and work on that.disconnect users and disable incoming connections to the database.While this particular database wasn't fixed, i guess the solution is try IB FirstAID. is wrong type (expected 0 found 1) I have a 200 GB Firebird database (created with Firebird 2.1.3, currently running 2.1.5), and it appears to be corrupted. If backup completed successfully, restore the database: gbak -c -v -user SYSDBA. Start Firebird server and run the following commands: gfix.exe -v -full -user SYSDBA -pass masterkey pathtoyourdatabase gfix.exe -mend -ig -user SYSDBA -pass masterkey pathtoyourdatabase gbak -b -g -v -user SYSDBA -pass masterkey pathtoyourdatabase pathtobackup Try to run them all, even if gfix shows errors. It's even able to create the structure for Firebird database from scratch, so you can use it as a migration tool to migrate from other DBMS systems. If you wish to import data from non-Firebird data sources, then IB DataPump is probably the best free option available.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |