Online Documentation for SQL Manager for InterBase/Firebird

Restore from Full Backup


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

 

Restore Database - Restore from Full Backup

 

 

Source file

Type in or use the ExplorerButton button to specify the backup file from which the restore operation should be performed.

 

Restore into

Specify the database into which you want to restore one from the source file.

 

RadioButton New database (into database file)

Select this option to create a new database to restore the backup into.

 

Host

This group allows you to define the host on which the new database will be located.

 

RadioButton Existing host

Specifies that the database to be created will reside on an existing (already registered) host. Use the Host name drop-down list to select the host for the new database.

RadioButton New host

Specifies that the database to be created will reside on a new host. If this option is selected, you will need to specify new host options at the next step. For details see Setting connection parameters, SSH tunneling parameters.

 

RadioButton Existing database (into database)

Select this option to restore the backup into an existing (already registered) database. Select the necessary database from the drop-down list, and  use the Login as group to specify the User name and Password to access the database.

 

CheckBox Shutdown database before service start

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

 

CheckBox Bring database online after service finished

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

 

Execution mode

RadioButton Use local utilities

Select this option to restore the database using local utilities.

 

RadioButton Use services

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

 

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

 

Restore mode

RadioButton Local

Select this option to store the restore 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 restore file on the server machine.