MS SQL® Database Maintenance

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® and SQLServer® .

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 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® Database Maintenance, PostgreSQL® Commands and MS SQL® Database Maintenance.

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).

.

MS SQL®: backupMSSQLServer.cmd [<command> <argument>] <MSSQLServer-backup-path>

MS SQL®: restoreMSSQLServer.cmd [<command> <argument>] <MSSQLServer-backup-path>