Full DB Backup and Restore

The NGA Database Backup feature is an operation to backup (and if required, restore) the complete database(s) used by NGA and is therefore specific to the DB usedInfluxDB®, PostgreSQL® and SQLServer®

Note:
The backups are based on online backup features of the underlying databases and do not require a shutdown of the database and / or the WinCC OA project. Note that the performance of the database will be reduced while the backup is active.
Note:
Normally a backup of (external) databases is in the domain of the Database Admin.

There is a WinCC OA-panel for executing the PostgreSQL® backup/restore operation - see NGA PostgreSQL® Backup and Restore

To back up or restore an entire database, use the appropriate backup or restore script for your DB type or platform.

These are scripts that do a full backup of the current state of the database. These can be used when data is lost for some reason:
  • For backup and restore of the InfluxDB®, use the commands described in the chapter InfluxDB® Commands.
  • For backup and restore of the PostgreSQL®, use the commands described in the chapter PostgreSQL® Commands.
  • For backup and restore of the MS SQL®, use the commands described in the chapter MS SQL® Commands.

Other WinCC OA Backup Options

  • The Segment backup integrated in the NGA (see General configuration for all backends can be used for restoration of historic data which has already been deleted due to retention settings ("lifetime" of data).