Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Netflow Traffic Analyzer (NTA) > NTA 4.2.2 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

Tags

Classifications

Public