Subject Issues restoring a Firebird Database
Author

Hello there. I have been trying to use different restores for the past couple of weeks for one specific database and it seems I am able to restore the database with data in the database restores tables but it does not have any procedures or views or anything like that. I am able to restore other databases fine and I am using the same command for all. The screen output and execution for the troublesome database appears to just stop. Is anyone able to give me insight into this issue?


Here is the command I am using:

gbak -create -recreate -replace -verify -user XXX -password YYYY "c:\somepath\somefile.bak" Server:c:\somepath\somefile.fdb



Here is the restore log of a successful db restore:

gbak:    activating and creating deferred index FK_xxxxxxxxx

gbak:    activating and creating deferred index FK_yyyyyyyyy

gbak:    activating and creating deferred index FK_zzzzzzzzz

gbak:committing metadata

gbak:fixing views dbkey length

gbak:updating ownership of packages, procedures and tables

gbak:adding missing privileges

gbak:fixing system generators

gbak:finishing, closing, and going home

gbak:adjusting the ONLINE and FORCED WRITES flags



Here is the restore log for the problematic db restore:

gbak:    activating and creating deferred index FK_xxxxxxxxx

gbak:    activating and creating deferred index FK_yyyyyyyyy

gbak:    activating and creating deferred index FK_zzzzzzzzz

gbak:committing metadata