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
 

Reply via email to