Previous Topic: Back up the Configuration and DataNext Topic: Back up the Directories and Data


Back up the Databases

SQL Management Studio enables you to back up the Management and Performance Databases.

Follow these steps:

  1. Launch the SQL Server Management Studio.
  2. Expand the registered SQL Server where AOM2 and DPM databases reside.
  3. Expand Databases.
  4. Right-click the database, click Tasks, then Back Up.
  5. Verify that the Backup type is set to Full and identify the path to where the backup is made.
  6. Click OK.

The following table presents the recommendations for the Performance and Management Databases:

Database

Description

Recommendation

AOM2

Management Database

Incremental backup

DPM

Performance Database

The Performance Database contains performance metrics collected by the agents. Unless this data is deemed critical from a historical point of view, it is not recommended to back up this database.