Online Documentation for SQL Manager for InterBase/Firebird
Backup a database
A database backup is created by means of the Backup Database Wizard. To launch it and set necessary backup options choose Services | Backup Database main menu item.
Backup Database Wizard allows you to make a backup on the local or remote host.
To create a local database backup:
- Select the Use local utilities option in the Execution mode group. To enable this mode, you need to specify the location of the utilities in the Path to database utilities field on the Connection page of the Host Registration Info dialog, and gbak.exe and nbackup.exe (for Firebird multi-level backup) files must exist in this directory.
- Select the Local option in the Store mode group to store the backup file on the local machine.
Note: Backup of a database located on the Embedded host is only possible with local tools used. You need icudt30.dll, icuin30.dll, icuuc30.dll and fbembed.dll (fbembed.dll must be renamed to fbclient.dll) to be located along with gbak.exe file inside the directory specified in the Path to database utilities field on the Connection page of the Host Registration Info dialog.
To create a database backup on the remote host:
- Select the Use services option in the Execution mode group to use the server services for the backup operation.
- Select the Server option in the Store mode group to store the backup file on the server machine.