Check and Back Up the Databases › Back Up the Databases and Restart the Services

Back Up the Databases and Restart the Services

Before you upgrade, back up the databases and files that are listed in the following table.

Important:

• Run backups concurrently. If you restore data from backups that have different timestamps, problems can result. Ensure that your backed-up data files are timestamped with the same hour.
• Store backups to a remote location to guard against the possibility of a hardware or operating system failure on the main server. For example, back up the databases to an administrative share or mapped network drive.

The following list describes the databases and their locations:

• reporter: Back up the previous 24 hours of Enterprise Overview data, NFA console configuration settings, and synchronization information.

  Path: <install_path>\MySql\data\reporter directory

• harvester: Back up the Harvester configuration data.

  Path: <install_path>\MySql\data\harvester directory

• nqrptr: Back up the configuration data for collecting historical (15-minute data) on the DSA servers in a three-tier deployment.

  Path: <install_path>\MySql\data\nqrptr directory

• nsas: If CA Anomaly Detector is installed on the same server as the NFA console or the stand-alone server, back up the configuration data for running CA Anomaly Detector. If CA Anomaly Detector is located on its own server, you can perform this backup when you upgrade CA Anomaly Detector.

  Path: <install_path>\MySql\data\nsas

• poller: Back up the Poller configuration data. The poller and harvester configuration data are essential to perform the relational mapping that provides access to 15-minute data. The poller configuration data provides information about devices and interfaces to enable polling, such as persistent IDs for interfaces.

  Path: <install_path>\MySql\data\poller directory

• ReaperArchive15: Optionally, back up the historical (15-minute) data that is stored for the reporting routers and interfaces. This backup is optional, but many administrators do back up the 15-minute data.

  Path: <install_path>\Netflow\datafiles\ReaperArchive15 directory

• Customized configuration files: Back up any customized configuration files--files that you customized or that were customized by CA Support. In addition, back up any customizations that you made to the website or reports.

  The CA Network Flow Analysis configuration files typically have a .config, conf., or .ini extension and are located in the product installation path. Other customizations may include .css files and report logos.

• ReaperArchive: (Recommended) Back up the historical (15-minute) data.

  Path: <install_path>\Netflow\datafiles\ReaperArchive directory

• Customized data_retention: If you customized any data retention settings, back up the data retention configuration data. It is unusual to customize data retention settings except with the assistance of CA Support. Changes to data retention settings can cause problems from rising demands on drive space.

  Path: <install_path>\MySql\data\data_retention directory

Follow these steps:

1. Log in as a user who has administrator privileges for CA Network Flow Analysis.
2. Connect to the server:
   1. Open a Remote Desktop session.
   2. Initiate a Terminal Services or VNC session to the installation server.
3. Copy each target directory and file to a remote location.
4. Restart the services.