Incremental backups with Firebird component nbackup

Aus Wiki - Heidler Strichcode GmbH
Zur Navigation springen Zur Suche springen


FirebirdLogo.png

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.

 Backup Plan EN.png

Recovery

For example, if you want to restore a backup from week 1, Wednesday 09:00, you will need the following data:

  NBackup Restoring.png

nbackup flowcharts

Backup

Nbackup backup flowchart.png

 

 

Recovery

 

Nbackup recovery flowchart.png


Configuration nbackup

https://www.firebirdsql.org/file/documentation/html/en/firebirddocs/nbackup/firebird-nbackup.html