Choose your Backup Strategy for Aternity 11

There are many ways to backup your data. Data backup can help you protect and restore your data when something goes wrong.

Types Description

A data backup is the process of copying files and folders for the purpose of restoring them in case of data loss. Backup files can be stored on the same server or copied to a different one.

Read this article for backup procedures of various components.


Redundancy is the duplication of nodes.

The level of failure tolerance is a value known as K-safety (or K-safe)K-safety=1 indicates you maintain availability when one node fails.

There is a separate article on redundancy and high availability.

High Availability

High availability ensures an agreed level of operational performance, usually uptime, for a higher than normal period. For example, adding a dual UPS adds high(er) availability to power systems. This implies the system is resilient enough to survive a disaster. Implementing high availability on its own, however, does not achieve disaster recovery.

Install a Vertica cluster for performance and high availability

Since the Aternity Dashboard Server connects to only one Vertica Database Server, if that server fails, it cannot connect to any servers in the cluster. Therefore you should connect the Dashboard Server to a load balancer to ensure high availability.

There is a separate article on redundancy and high availability.

Disaster Recovery (hot recovery)

Disaster recovery is the process that allows your organization to continue computer and network operations in the event of a computer or equipment disaster.

You can create an entire standby data center site which is ready to spring into action if your main site becomes unavailable, also known as hot recovery.

Data replication involves storing the same data on multiple storage devices according to scheduling algorithms. It ensures consistency between redundant resources, such as software or hardware components, to improve reliability, fault-tolerance, or accessibility.

Aternity offers a disaster recovery solution for on-premise v11.0.2 and later.

Learn how to set up the hot standby site.

Learn how to switch to a hot standby site in case of disaster.


For details of restoring from backups, see Restore Backups for Aternity 11.

Aternity recommends to backup the data so that all company data is available regardless of whether a hot standby site or main site is used.

The strategy of backing up Aternity on-premise servers focuses on keeping only the dynamic data which is valuable to you and hard to replace. For most Aternity servers, their data is easily repopulated after a restore, and therefore do not need a backup.

We recommend backing up only the following Aternity on-premise servers:

Aternity servers for backup
Component name Contains Backup Frequency

Aternity Oracle Database Server

  • Local usernames and passwords (encrypted).

  • User privileges, roles, and preferences.

  • System settings.

Perform incremental backup daily plus a full backup every week.


You must enable the archive log by switching on the Oracle FORCE_LOGGING setting.

You can also deploy live backups for high availability. Learn more.

Aternity Management Server

  • Several crucial static files required for database disaster recovery, which must be backed up.

  • Aternity quickly repopulates the performance baselines after a restore.

After every Aternity upgrade, backup the disk image.

You can also deploy a failover server for high availability. Learn more.

Aternity Dashboard Server

If users saved their own custom dashboards, you can create a backup (see below).

Create a scheduled execution of the command line regularly (daily or weekly according to your requirement).

Aternity Vertica Database Server

The Aternity Vertica Database Server stores the performance data from the past 31 days in the Vertica format, which is most efficient for displaying in Aternity dashboards.

  • Perform an incremental backup daily. You can keep the backup files on that same server or copy them to another machine. Learn more.
  • Prepare Aternity Vertica Database Server for high availability. Learn more.
  • Implement disaster recovery for your deployment, and if the whole site fails, switch to the hot standby. Learn more.

Customized and saved dashboards

Create a Backup of your Saved Dashboards. Learn more.

The Agent for End User Devices reports data to Aternity once every minute. If its status becomes disconnected and it cannot send data after trying for five minutes, it locally stores up to 50 minutes of retention data in offline mode, and then sends it when it renews its connection.

Aternity does not provide backup procedures for the following servers:

Component name Contains Backup Frequency

Aternity Data Warehouse Server

Detailed recent performance data (up to seven days) is quickly repopulated after restore.

Not available

Aternity Dashboard Server

Programs and settings to display the data in dashboards, fully restored with a standard installation.

Not available

Aternity Aggregation Server

Programs and settings to condense data for passing on to other Aternity servers, fully restored with a standard installation.

Not available

Aternity Raw Data Docker Component (Cassandra)

Stores the detailed information and measurements for monitored devices for a maximum of 7 days.

Not available

Create a Backup of your Saved Dashboards

You can save and share a customized dashboard, to revisit it any time in the Main Menu. To save, share and subscribe, you first view a dashboard, customize it, then share with people and subscribe someone to regular email updates, and finally you save it. (Learn more)

Subscribe and share a dashboard

To create a backup of saved dashboards, create a scheduled running of a command line utility on the Dashboard Server. Navigate to the setup destination directory of the Dashboard Gateway.

Enter the following command:

TableauUtility.cmd backupSaved -outputFolder target_dir -site Tableau_site
Backup saved dashboards with a scheduled command line
Field Description


Enter the target directory to place the backup package (zip file) containing the saved dashboards. For example, c:\temp.


Enter the name of the Tableau site. You can find this in Aternity settings, by selecting the Gear Icon > Settings > Advanced Settings > tableau > site.