Backing up / restoring multiple-file databases

Backing up / restoring multiple-file databases

Backing up / restoring multiple-file databases : Multi-thousand tips to make your life easier.

How to back up split databases so that the resulting files are also split, and then how to restore them again.

To back up a multi-file database example.gdb + example.gd2 + example.gd3 to the backup files example.gbk + example.gb2 + example.gb3, use the following:

gbak -B -T -password masterkey -user sysdba -v example.gdb
example.gbk 1G example.gb2 1G example.gb3 1G etc.

Add every backup file to the command line in the form filename size, in bytes or M/G for megabytes or gigabytes.

To restore a multi-file backup, use the following:
gbak -r -o -p 8192 -password masterkey -user sysdba -v
example.gbk example.gb2 example.gb3 (continue...)
example.gdb 250000 example.gd2 250000 example.gd3

You have to include every backup file in the command line.

This works in the original open source release of InterBase.