Incremental backups with Firebird component nbackup
Nbackup is a Firebird feature which has been introduced for version 2.0 and higher. It enables backups to be created during operation and in incremental steps. The backup contains all data at the time the backup was started.
General
Backup level
A backup is divided into levels. Level 0 is a full backup. Level 1 is an incremental backup of the last level 0 backup. Level 2 is an incremental backup of the last level 1 backup. General: A level (n) backup is an incremental backup of the last level (n-1) backup.
Restrictions of the backups
Incremental backups cannot be created and restored in every combination. The following restrictions therefore always apply:
- No repair measures are carried out as with gbak.
- Backups can only be performed on the local system.
- The backups created cannot be used independently as a database. They have to be restored first.
General information
- Firebird 1.5 is not supported.
- Performance of the entire system is an important factor. In particular, the drive and, in the case of incremental backups, the CPU are heavily loaded.
- Sufficient storage capacity is required.
- If you have HVS32DB archiving, you must ensure that it is not executed at the same time as nbackup.
Backup / Recovery
Backup plan
This is an example of what a backup plan could look like. It creates a weekly full backup and a daily and hourly incremental backup.
Recovery
For example, if you want to restore a backup from week 1, Wednesday 09:00, you will need the following data:
nbackup flowcharts
Backup
Recovery
Configuration nbackup
https://www.firebirdsql.org/file/documentation/html/en/firebirddocs/nbackup/firebird-nbackup.html