Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Netflow Traffic Analyzer (NTA) > NTA 4.2.3 Administrator Guide > NTA settings > Best practices for NTA Flow Storage Database backups

Best practices for NTA Flow Storage Database backups

Best practices for Flow Storage Database backups

Considerations when scheduling backups

Higher utilization of resources

During the backup, your computer resources may be more utilized.

Initial backups take longer

The first database backup includes all data and is more time-consuming than further regular backups.

If you migrate your data from a SQL database to the Flow Storage Database, the first backup after the migration takes longer because the database contains the migrated data.

Backups and update operations do not run simultaneously

If you launch an update operation when a backup is in progress, the updates are applied after the backup completes.

Update operations include:

  • Changing the status of applications from monitored to unmonitored, or from unmonitored to monitored.
  • Creating, updating, removing, enabling, or disabling IP groups.
  • Enabling or disabling interfaces.


If there is an update operation running when the backup starts, the backup will start after the update finishes.

Restoring backups: pick up where you finished last time

Updates are stored in a separate file which is updated regularly. When restoring the backup, NTA applies the most recent update settings on the backed up data. When you restore a backup, you will get your data in the same status as they were before the restore.

Optimize your backups

  • Execute backups at times when the utilization of your network is low, preferably at night.
  • Set high frequency for your backups. Backups are executed incrementally, only the new data are added to the backup. If you therefore set backups for each day, the backup will be executed more smoothly than if you back up your database once a month.
  • Do not use the same physical drive for saving your Flow Storage Database and your backups.
    • Flow Storage Database performance decreases during the backup.
    • If the hard drive fails, you will not be able to restore your database.
  • Do not schedule backups at the same time as maintenance. Both maintenance and backup are performance-intensive processes and running them at the same time may have a negatively affect SolarWinds NTA.
Last modified
09:02, 13 Apr 2017