Back Up the Databases

Maintenance and Data Collection › How to Back Up and Restore 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:

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.

Follow these steps:

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

Database	Stand-Alone 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

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: <install_path>\MySql51\data\data_retention
- harvester database: <install_path>\MySql51\data\harvester
- HarvesterArchive database: <install_path>\Netflow\datafiles\HarvesterArchive
- nqrptr database: <install_path>\MySql51\data\nqrptr
- poller database: <install_path>\MySql51\data\poller
- ReaperArchive database: <install_path>\Netflow\datafiles\ReaperArchive
- ReaperArchive15 database: <install_path>\Netflow\datafiles\ReaperArchive15
- reporter database: <install_path>\MySql51\data\reporter
- Single Sign-On (SSO) configuration files: Back up the following files and directories on the SSO server, which may be the 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.