Subject | Re: [firebird-support] Issues restoring a Firebird Database |
---|---|
Author | |
Post date | 2019-04-29T16:16:18Z |
Thanks for the response Helen. I will update the restore as you suggested. Here is some more information:
There is nothing in Firebird.log regarding the restore.
Before the restore the script executes the following:
gfix -shut -force 30 db1.fdb
After the restore:
gfix -online db1.fdb
I am executing the same backup command that I use for all the other databases and there are procedures, views, etc in those. I do remember doing a metadata only backup on the source once but I would think that wouldn't change anything on future runs...
The source database is on Linux running Firebird version 2.5.5.26952.0-2.el6
The target database is on Windows Azure VM running Firebird 3.0.4.33054. I do not think there is any virus program running there unless Azure and/or VM is doing something.
I am using the gbak utility that corresponds to each version.
The method I use to get the backup file to the windows server is Putty pscp
I have managed to restore a db with a different name in the past and that worked but even when I delete the database the restore makes a database that is incomplete. I am attempting a restore with a 3rd different name now.
The syntax I am using for the backup is:
gbak -b -z -V /var/lib/firebird/data/db1.fdb /var/lib/firebird/data/backups/db1.bak
I do have logs from the backup from both appear to be the same. The end of both are similar as follows:
gbak:writing names mapping
gbak:closing file, committing, and finishing. 61055743488 bytes written
The log is quite large but didn't find anything in it when searching for word error or fail