Network Management

Migrate the NTA Flow Storage database from one SQL server to another

This article describes the steps for migrating the NTA Flow Storage database from one SQL server to another.

First published date

12/12/2019 3:14 PM

Last published date

1/21/2026 4:23 PM

Overview

The steps below provide guidance to migrating the NTA Flow Storage database (in NTA 4.4 and later) from one SQL server to another.

Product section

Netflow Traffic Analyzer

Resolution

On the Main Polling Engine

Note: Following the steps below will create a new SQL database, and you will lose your flow data. If you want to keep them, the original Flow Storage database needs to be backed up and restored on the new SQL server.

Run the SolarWinds Configuration wizard.
On the page NTA Flow Storage Configuration - Select the SQL Server for NTA Flow Storage:
1. Enter the new SQL server connection information.
2. Use credentials with permission to create a new database.
3. Click Next.
On the page NTA Flow Storage Configuration - Select the SQL Server Database to create or select an existing database, select Create a new database, and click Next.
Complete the Configuration wizard.

During the configuration wizard, it may be necessary to create a new NTA database user through the configuration wizard using a sysadmin role user such as 'sa' to resolve any connection issues. The following screenshots walk through the NTA Flow Storage Configuration database user screens and give examples of how to create a new user of your choosing:

On Additional Polling Engine / Web / Main HA backup / Polling Engine HA backup

Run the SolarWinds Configuration wizard.
On the page NTA Flow Storage Configuration - Select the SQL Server for NTA Flow Storage, enter the new SQL server connection information, and click Next.
On the page NTA Flow Storage Configuration - Select the SQL Server Database to create or select an existing database, select Use an existing database, and click Next.
Complete the Configuration wizard.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.