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® 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.
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® Database Maintenance.
- For backup and restore of the MS SQL®, use the commands described in the chapter
MS SQL® Database Maintenance.
Note:For PostgreSQL® backup you can use the NGA PostgreSQL® Backup and Restore feature.
Other WinCC OA Backup Options
- The Settings Tabis 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).
.
