Online Documentation for SQL Manager for InterBase/Firebird
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 | 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:
- 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.
- Choose the 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:
- Select the Use services option in the Execution mode group to use the server services for the restore operation.
- Choose the Server option in the Restore mode group to store the restore file on the server machine.