Back Up the Databases

Understanding and Maintaining Collected Data › How to Back Up and Restore CA Network Flow Analysis Data › Back Up the Databases

Back Up the Databases

When you have stopped the services on the CA Network Flow Analysis component servers and have verified that the HarvesterWork directories are empty, you are ready to perform the backups.

Important:

Make the backups run 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 OS failure on the main server. For example, back up the databases to an administrative share or mapped network drive.

Follow these steps:

Determine which CA Network Flow Analysis databases and files to back up.
The CA Network Flow Analysis databases and files to back up are listed in the following table and are described in Databases to Back Up.

Database	Standalone Server	Harvester Servers (Distributed)	NFA Console Server (Distributed)	DSA (3-Tier Distributed)
reporter	Important		Important
harvester	Important	Important
poller	Important	Important
ReaperArchive15	Recommended	Recommended		Recommended
Customized Files	Important	Important	Important	Important
Customized data_retention	Important if customized	Important if customized		Important if customized
HarvesterArchive	Optional, rarely backed up	Optional, rarely backed up
ReaperArchive	Optional, rarely backed up	Optional, rarely backed up
nqrptr				Important
Windows Registry	Important	Important (Windows)	Important	Important

Copy each of the target directories or files to a remote location.
The following list identifies database locations:
- Customized configuration files: Various locations
- Customized data_retention database: <NFA_Install_Path>\MySql51\data\data_retention
- harvester database: <NFA_Install_Path>\MySql51\data\harvester
- HarvesterArchive database: <NFA_Install_Path>\Netflow\datafiles\HarvesterArchive
- nqrptr database: <NFA_Install_Path>\MySql51\data\nqrptr
- poller database: <NFA_Install_Path>\MySql51\data\poller
- ReaperArchive database: <NFA_Install_Path>\Netflow\datafiles\ReaperArchive
- ReaperArchive15 database: <NFA_Install_Path>\Netflow\datafiles\ReaperArchive15
- reporter database: <NFA_Install_Path>\MySql51\data\reporter
- Windows Registry:
  Back up the Registry as a .reg file by selecting File, Export in the Registry Editor window. For more information about the new location of Harvester settings, see the Release Notes topic "Relocation of Harvester Settings."
- Single Sign-On (SSO) configuration files: Back up the following files and directories on the SSO server, which may be the CA Performance Center server:
  - <Install_Path>\Portal\SSO\start.ini file
  - <Install_Path>\Portal\SSO\etc directory
  - <Install_Path>\Portal\SSO\conf\wrapper.conf file
  - <Install_Path>\Portal\SSO\webapps\sso\configuration directory
Restart the NetQoS Mysql51 service and the dependent CA Network Flow Analysis services:
1. Right-click the NetQoS Mysql51 service in the Services window and click Restart.
  The Restart Other Services confirmation message opens and lists all the dependent CA Network Flow Analysis services that will also restart.
2. Click Yes.
3. The confirmation message closes and the services stop and start again.
Restart the CA Network Flow Analysis services.