• complete In this case, all selected items (complete server, databases or files) are saved in their entirety. This backup is more secured because it is sufficient to restore the elements. It is longer to perform because everything is saved.
• differential in this case, only the differences from a full backup are saved. This backup is faster to perform and less bulky. It must be stored with the full backup that corresponds to it.

Make an immediate backup

Attention An immediate backup is necessarily complete.

1. If necessary, connect to an HFSQL server and display the description of the server or one of its databases (double-click on the server or database name in the tree structure).
2. Click the "Backups" tab.
3. In the ribbon, in the "Backups" group, expand "New backup" and select "New hot backup". The wizard for creating a backup starts.
4. Specify the content of the backup:
   • The entire content of the server.
   • A specific database.
   • A selection of databases and/or data files.
   Proceed to the next step of the wizard.
5. Specify backup options:
   • whether the result of the backup must be compressed in a zip file.
   • whether the backup is to contain index files (NDX index files, FTX full-text index files, etc.). If the index files are not saved, the size of the backup will be reduced but the restore time will be longer.
     Note If index files are not saved, it will be necessary to provide the file passwords at the time of restoration, to enable them to be re-indexed.
6. Proceed to the next step of the wizard.
7. Specify the backup location by specifying the backup directory.
   If this name corresponds to a relative path, the backup will be performed in the "Backup" subdirectory of the HFSQL server. The wizard is used to define a "backup" subdirectory ("Backups" by default).
   You can add the date and time (in the form "Year\Month\Day\Hour-Minute") to the directory name to easily identify the backup.
   Note Backups are made in a numbered subdirectory (e.g. "backup\Backups\1"). Therefore, if several backups are performed, the corresponding files will not be overwritten by a new backup.
8. Proceed to the next step of the wizard.
9. Specify the actions associated with the backup:
   • Procedure stored before or after backup: In this case, the next step in the wizard allows you to specify:
     • the name of the database containing the stored procedure to run,
     • the name of the set of procedures containing the stored procedure to run,
     • the name of the procedure to run.
   • Webhook executed after backup: In this case, the next step in the wizard allows you to specify the URL of the webhook (REST service) to which the backup result should be sent..
10. Give a description to your backup and validate.
11. The backup is automatically started. The progress of the backup can be monitored in the HFSQL Control Center.

Creating a scheduled backup

1. Click the "Backups" tab.
2. In the ribbon, in the "Backups" group, expand "New backup" and select "New scheduled backup". The wizard for creating a backup starts.
3. Specify the content of the backup:
   • The entire content of the server.
   • A specific database.
   • A selection of databases and/or data files.
4. Specify backup options:
   • whether the result of the backup must be compressed in zip format.
   • whether the backup is to contain index files (NDX index files, FTX full-text index files, etc.). If the index files are not saved, the size of the backup will be reduced but the restore time will be longer.
     Note If index files are not saved, it will be necessary to provide the file passwords at the time of restoration, to enable them to be re-indexed.
5. Proceed to the next step of the wizard.
6. Choose a scheduling scenario among the preset scenarios.
   • Complete monthly backups with the option of weekly or daily differential Backups.
   • Full weekly backup with daily differential backup option.
   • Full daily backup.
   You can also choose a custom scheduling. In this case, the next steps of the wizard will guide you through the definition of the schedule.
7. Proceed to the next step of the wizard.
8. Specify the backup location by specifying the backup directory.
   If this name corresponds to a relative path, the backup will be performed in the "Backup" subdirectory of the HFSQL server. The wizard is used to define a "backup" subdirectory ("Backups" by default).
   You can add the date and time (in the form "Year\Month\Day\Hour-Minute") to the directory name to easily identify the backup.
   Note Backups are made in a numbered subdirectory (e.g. "backup\Backups\1"). Therefore, if several backups are performed, the corresponding files will not be overwritten by a new backup..
9. Specify the actions associated with the backup:
   • Procedure stored before or after backup: In this case, the next step in the wizard allows you to specify:
     • the name of the database containing the stored procedure to run,
     • the name of the set of procedures containing the stored procedure to run,
     • the name of the procedure to run.
   • New in version 2025
     Upload the backup to an FTP server: In this case, the next step in the wizard allows you to define the connection options to the FTP server and the location where the backup will be copied.
   • Webhook executed after backup: In this case, the next step in the wizard allows you to specify the URL of the webhook (REST service) to which the backup result should be sent..
10. Specify whether you want to limit the number of backups stored on the server.
11. Give a description to your backup and validate.
12. The backup definition appears in the "Scheduled items" tab.

Operations on the backups

• Edit backup description.
• Run the backup directly.

• Restore a backup in a zip file or in a specific directory.
• Delete a backup. To delete a backup, you must be a "Superuser".
• Restart a backup.
• Recovering a backup on the client workstation.

1. If necessary, connect to an HFSQL server and display the appropriate server or database tab.
2. Click the "Scheduled elements" tab.
3. Select the scheduled backup you wish to modify.
4. In the ribbon, in the "Scheduled elements" group, click "Edit".
   You also have the ability to use the context menu of the scheduled element ("Edit" option).
5. The planned item description window appears. All features are grouped together on several tabs:
   • Tab "General": Defines if the backup is active.
   • Tab "Scheduling": Defines the execution options for the scheduled backup (month, day, hour, number of executions, execution at startup).
   • Tab "Backups": Defines the backup options (backup content, location, etc.)
   • New in version 2025
     Tab "Execution History": This tab appears when the backup has been executed automatically. This tab lists the various automatic executions of the scheduled backup, indicating:

     • the backup start date,
     • backup status: completed, in progress, error,
     • running time,
     • the user who launched the backup,
     • if launched manually (via HExecuteScheduling).
6. Validate.