Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

Home > Success Center > Archive > 2018June04 - NTA Deletes > Best practices for NTA Flow Storage Database backups

Best practices for NTA 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. If there is an update operation running when the backup starts, the backup will start after the update finishes. 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.
  • 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

Tags

This page has no custom tags.

Classifications

Internal Use Only