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 used (InfluxDB®, PostgreSQL®, 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.

There is no WinCC OA panel to perform the backup / restore operation and instead sample scripts (cmd or shell scripts) are provided for this purpose. It is recommended to include these backup scripts in the scheduler / crontab entries of your operating system. See the description below.

  • To backup or restore a full database, use the appropriate backup or restore script for your database type and platform..
  • Create a a scheduled task (windows) / cronjob (linux) that executes the backup scripts regularly as follows:
  • Create a task via the Windows Task Scheduler. In the Windows Start menu type in "Task" and open the Windows Task Scheduler.
  • Use the scripts from <WinCC OA_path>/data/NGA/<Database Type>/sql for a task.

These are scripts that do a full backup of the current state of the database that can be used if there is a major malfunction that requires that the whole database is restored. For a detailed description of the backup and restore commands, see chapters InfluxDB® Commands, PostgreSQL® Commands and MS SQL® Commands.

Other WinCC OA Backup Options

  • The WinCC OA "Online Backup" feature is to recreate a WinCC OA project in case of data loss or other fatal situations (hardware fault, unwanted manual deletion of data, ...). The online backup is a complete backup of a WinCC OA project. Note that this backup does not include the history database.
  • The Segment backup integrated in the NGA (see Extended Settings - Database-specific Configuration) can be used for restoration of historic data which has already been deleted due to retention settings ("lifetime" of data).

.