- The different types of backups
- Full backup and differential backup
- Immediate backups and scheduled backups
- Characteristics of the backup
- Windows rights required to perform backups
HFSQL Client/Server: Principle for saving the databases
Available only with this kind of connection
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.
Several types of backups are available:
- full backup with or without differential backup.
- immediate or scheduled backup.
A backup can be triggered:
- in the HFSQL Control Center.
- through programming.
For more details, see How to perform a backup?
The different types of backups
Full backup and differential backup
A full backup consists in entirely saving the data found on a server, in a database, in a file, ... This type of backup requires a lot of space.
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.
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.
- 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 is using 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
The backup of an HFSQL Client/Server database is run by the process "manta.exe" (visible in the Windows service manager and named "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:
- Open the Windows service manager.
- Right-click "Hyper File Server : ServerName" and select "Properties".
- In the "Connection" pane, replace the "Local system account" by a user who has the rights to access the backup location.
This page is also available for…