ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / HFSQL / Managing HFSQL Client/Server
  • Overview
  • The different types of backups
  • Full backup and differential backup
  • Immediate backups and scheduled backups
  • Remarks
  • Characteristics of the backup
  • Notes
  • Windows rights required to perform backups
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
HFSQL Client/Server: Backing up databases
HFSQL Client/ServerAvailable only with this kind of connection
Overview
Like for any database, backups of your HFSQL Client/Server databases must be performed on a regular basis.
This backup can be performed while the database is being used. In this case, the backup is a "hot" backup. Accesses can be in progress (read, write, execution of queries, etc.). The backup will correspond to the status of the database when the backup starts.
What backup options are available?
Several types of backups are available:
How do I make a backup? '
A backup can be triggered:
  • in the HFSQL Control Center.
  • programmatically.
For more details, see How to perform a backup?.
How do I restore a backup?
A backup can be restored at any time. For more details, see How to restore a backup?.
The different types of backups

Full backup and differential backup

A full backup consists in backing up all the data on a server, a database, a data file, etc. This type of backup quickly becomes space-hungry.
You can also perform differential backups. The differential backup is used to save the file sections modified since the previous full backup. Therefore, the size of backups is considerably reduced and the speed of backups is increased.
The common method consists in performing full backups at fixed dates and in performing differential backups between these fixed dates. The frequencies depend on the rate of data evolution and on the importance of data. A correct frequency consists in performing a full monthly backup and a different backup every night.

Immediate backups and scheduled backups

The immediate backups are used to perform a backup at a given time. Only a full backup can be performed immediately.
The scheduled backups are used to implement an automatic backup policy by defining the frequency of backups. The full backups and the differential backups can be scheduled.
Remarks

Characteristics of the backup

The backup performed will correspond to the status of the database at the beginning of backup.
During the backup, you are not allowed to:
  • delete files and databases,
  • update the stored procedures.

Notes

  • A full backup can be performed immediately or it can be scheduled.
  • A differential backup can only be scheduled.
  • We advise you to perform the backups when the server load is light. Indeed, the backup uses the hard disk and it may slow down the server.
  • If the backup is a scheduled backup and if the server is switched off when the backup must be performed, the backup will be performed at the next specified date, when the server is available.
  • Performing a backup and restoring it under a different name allows you to easily duplicate a database.

Windows rights required to perform backups

Backup of an HFSQL Client/Server database is performed by the "manta.exe" process (visible in the Windows Service Manager as "Hyper File Server: ServerName").
By default, this service is run by the "local system account" of Windows, whose rights can be limited.
If a backup fails with an error such as "Access denied" or "Unable to create the directory", the account used to run the service must be modified:
  1. Open the Windows service manager.
  2. Right-click on the "Hyper File Server: ServerName" service and select "Properties".
  3. In the "Connection" pane, replace the "Local system account" by a user who has the rights to access the backup location.
Minimum version required
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help