Online Documentation for SQL Manager for InterBase/Firebird

Full Backup options


If RadioButton Full backup is specified as the backup type, you need to set full backup options.

 

Backup Database - Backup type - Full Backup options

 

 

CheckBox Shutdown database before service start

Select this option to shutdown the database before running backup. For details see Start/Stop Database.

 

CheckBox Bring database online after service finished

Select this option to bring the database online after running backup. For details see Start/Stop Database.

 

CheckBox Compression

If this option is selected, the backup file will be compressed by the application. This option is available only if the backup file is located on the local computer.

Note: You can use compressed backup files as the source in Restore Database Wizard.

 

 

Execution mode

RadioButton Use local utilities

Select this option to backup the database using local utilities.

Note: 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.

 

RadioButton Use services

Select this option to use the server services for the backup operation.

 

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.

 

 

Store mode

RadioButton Local

Select this option to store the backup file on the local machine. This mode is available only when you select Use local utilities in the Execution mode group.

 

RadioButton Server

Select this option to store the backup file on the server machine.