Archiv für den Monat Oktober 2017

Firebird backup/restore commands

Before updating an existing database I always make a backup and restore of my database. So I have not only a backup but also a simple validation check. I create a simple batch file to repeat this procedure every time I do an update:

C:
cd "\Program Files (x86)\Firebird\Firebird_2_0\bin\"
gbak -v -t -user SYSDBA -password masterkey -b "localhost:C:\Database\MyDatabase.fdb" "C:\Database\MyDatabase.fbk"
gbak -v -user SYSDBA -password masterkey -c "C:\Database\MyDatabase.fbk" "localhost:C:\Database\MyDatabase_test_restore_before_update.fdb"
Pause

Weiterlesen