• 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.
• by programming.

• 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. Click the "Restore the backup" button.
5. Validate the restore operation.

• You also have the ability to restore a backup found in a specific server directory. To do so, click the "Restore a backup from a directory" button.
• If the backup is restored on a network disk (UNC or network drive letter), the necessary rights must have been granted to the user.
  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: Using a backup to copy and rename a database

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