• if the backup performed is a full backup, all you have to do is restore this backup.
• if the backup performed is a differential backup, all you have to do is restore the full backup and the associated differential backup.

• in the HFSQL Control Center.
• programmatically.

• To perform this operation, you must have the rights to perform a backup (hRightsBackup constant) as well as the rights to lock the database (hRightsLock constant).
• To restore the entire server (or the __jnl and __trs databases), no other application must be connected to the server. The connection used must not be attached to a database.
• To restore databases only, there must be no connection on the database to restore.

1. Select the HFSQL Client/Server server in the tree structure on the left of the screen.
2. Select the "Backups" tab.
3. In the table of existing backups, select the backup to restore.
4. In the backup context menu, select "Restore". The restoration wizard starts.
5. Validate the restore operation.

• It is also possible to restore a backup present in a specific directory on the server: in the ribbon, in the "Backups" group, pull down "Restore" and select "Restore a backup from a directory".
• It is also possible to restore a backup present in a zip file: in the ribbon, in the "Backups" group, pull down "Restore" and select "Restore a backup from a zip file".
• Warning If the backup is restored to a network drive (UNC or network drive letter), the user must have the necessary rights.
  In this case, to perform the restore operation:
  • specify a UNC path for the backup location,
  • modify the properties of the HFSQL Client/Server server via the Windows service manager by specifying a user who has the necessary rights in order to access the UNC location containing the backup.

To restore a database backup

Tip: Use a backup to copy and rename a database

1. Perform the backup the database.
2. Restore the database backup under a different name.