EMS logo

Products Navigation

SQL Manager for IB/FB

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for InterBase/Firebird

On-line Documentation

Restore a database from a backup


Use the Restore Database Wizard to restore a database from a backup. To launch the wizard and set restore options choose Services | iconServices_RestoreDatabase Restore Database main menu item.

Restore Database Wizard allows you to restore a database from a backup that resides on a local or remote server.

 

To restore a database from a local host:

  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. Choose the RadioButton Local option in the Restore mode group to store the restore file on the local machine.

 

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.

 

To restore a database from a remote host:

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