- Restoring a backup in the HFSQL Control Center
- Restoring a backup through programming
- To restore a database backup
- Tip: Using a backup to copy and rename a database
Restoring an HFSQL Client/Server database
Available only with this kind of connection
A backup of an HFSQL Client/Server database can be restored at any time:
- 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.
Reminder: The differential backup contains all the modifications performed since the previous full backup.
The restore operation can be triggered:
Caution: Restoring a backup must be done with great care.
- 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.
Remark: Performing a backup and restoring it under a different name allows you to easily duplicate a database.
Restoring a backup in the HFSQL Control Center
To restore a backup:
- Select the HFSQL Client/Server server in the tree structure on the left of the screen.
- Select the "Backups" tab.
- In the table of existing backups, select the backup to restore.
- Click the "Restore the backup" button.
- 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.
Restoring a backup through programming
To restore a database backup
Tip: Using a backup to copy and rename a database
To copy and rename a database, you have the ability to use the following tip:
- Perform the backup the database.
- Restore the database backup under a different name.
This page is also available for…