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 | iconServices_BackupDatabase 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:

  1. Select the RadioButton 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.
  2. Select the RadioButton 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:

  1. Select the RadioButton Use services option in the Execution mode group to use the server services for the backup operation.
  2. Select the RadioButton Server option in the Store mode group to store the backup file on the server machine.