Home
Data Management
Classify, structure and archive your data.
Archiving
Overview of the archiving solutions currently available in WinCC OA
NextGen Archiver (NGA)
The NextGenArchive (NGA) for is a archiving solution which extends flexibility while keeping the possibilities and strengths of the current methods. This chapter provides an overview of the NGA feature.
Database Maintenance
Overview of the database maintenance chapters for the NGA backends.
MS SQL® Database Maintenance

Version Information
Release Notes, Update information, Certifications and Frequently Asked Questions.
Concepts
Your first step into modern and powerful process visualization.
Deployment
Topics you need to know before using WinCC OA.
Security
Go beyond the norm in cybersecurity.
Engineering
Powerful tools for easy or complex engineering tasks.
Data Management
Classify, structure and archive your data.
- Archiving
  Overview of the archiving solutions currently available in WinCC OA
  - NextGen Archiver (NGA)
    The NextGenArchive (NGA) for is a archiving solution which extends flexibility while keeping the possibilities and strengths of the current methods. This chapter provides an overview of the NGA feature.
    - General Terms and User Model
    - Requirements and Installation
    - Licensing
      This chapter describes the NGA license options and available package sizes.
    - Deployment Scenarios
    - Configuration
    - InfluxDB®
    - PostgreSQL® Database Overview
    - MS SQL®
    - Redundancy
    - Using a Remote Backend with Encryption
    - Notes and Restrictions
    - Internal Data Points
    - Database Maintenance
      Overview of the database maintenance chapters for the NGA backends.
      - PostgreSQL® Database Maintenance
      - InfluxDB® Database Maintenance
      - MS SQL® Database Maintenance
      - Full DB Backup and Restore
      - NGA PostgreSQL® Backup and Restore
        This chapter describes the NGA PostgreSQL® backup and restore feature.
    - Estimation of the hard disk space
    - Debug Flags
    - CTRL Functions for NGA Access
    - HDB/RAIMA Migration
    - NGA Importer
    - NextGen Archiver (NGA) - FAQ
  - SQLite®
  - History DB
  - RDB Archiving
  - HDB/RAIMA - RDB Parallel
  - SQLite®/ RAIMA Online-Backup
  - Steps of the online DB backup process
- Module PARA
  Graphical interface for editing datapoints and datapoint types.
- Common Name Service (CNS)
  The plantmodel editor can be used for building and modifying data structures such as views and trees based on CNS and use them within projects easily.
- Mass configuration
  Mass configuration in WinCC OA redefines the fundamental principles of setting up a project and subsequent configuration of the huge range of data points.
- SQL Panel
  The SQL panel allows you to enter SQL statements to perform queries on current and archive data in the WinCC OA database.
- ASCII Manager
  The ASCII Manager allows you to input and output and thus edit data points and data point types and to configure data points.
- Correction Values and Laboratory Values
  These panels can be used to change existing values (=correct), query values from and add new values too the HistoryDB and RDB.
- Data Point Groups
  The main purpose of grouping data points is to simplify selection of datapoints and datapoint elements.
- Delayed Alerts
  An alert delay can be configured with delayed alerts. This allows short range changes to be filtered out.
- Relational Databases with Control-ADO
  The DB interfaces in WinCC OA offer the possibility of an access to external databases.
Business Logic / Control
Endless possibilities in data processing for your projects.
Data Visualization
User interfaces, Trends and Reports for every purpose and device.
Southbound Interfaces
The process connection to the actual machines/sensors.
Northbound Interfaces
Your portal to the cloud or supervising systems.
Web Connectivity / Network Interfaces
Data exchange, APIs and web technologies
User Management
All about authorization, authentication and login-customization.
Availability
How to get your system uptime to the maximum.
Reporting
Create state of the art project reports without limits.
Addons
Useful tools and enhancements for special demands.
Reference Tables
Detailed and extensive content for special project adaptation.
Videos & Tutorials
Explore the capabilities of WinCC OA with our carefully selected collection of video tutorials and guides.
Documentation
Basic information about terms and functions within the documentation.
Support & Services
An experienced team of support agents, consultants and trainers are ready to facilitate active partnerships with our customers, so they can profit from our comprehensive service.
Disclaimer
A brief clarification of liability exclusions or legal notices.

MS SQL® Database Maintenance

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.

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.

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.

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

.

MS SQL® Commands

The backup commands are available for MS SQL®. The command can be used for cmd and sh. This chapter describes the MS SQL® commands.

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


Command	Description
--database	Database to be backed up (the default is "winccoa").
--max-backup-count	Number of backups kept (the default is 3).

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


Command	Description
--database	The database to be restored (the default is "winccoa").
--backup	The backup folder name (e.g. 20211021-133236.bak) inside <MSSQLServer-backup-path> (the default is the newest backup).