Loading...

Knowledge Center


How to back up and restore the ePolicy Orchestrator database using SQL Server Management Studio
Technical Articles ID:   KB52126
Last Modified:  6/11/2019
Rated:


Environment

McAfee ePolicy Orchestrator (ePO) 5.x

To identify what versions of SQL Server are supported, see KB51569.

Summary

Sometimes Technical Support requires a backup of the ePO database. This article describes how to back up and restore the ePO database using SQL Server Management Studio. 

Alternative methods are covered in the following articles:
  • For how to back up the ePO databases using OSQL commands, see KB59562.
  • For how to use the command line to restore an ePO database, see KB55123.

Solution

To back up an ePO database using SQL Server Management Studio:

NOTES:
  • If you use the SQL Server Express Edition that ships with ePO, you can download and install SQL Server Management Studio Express from the Microsoft downloads page.
  • The steps in this article apply to all editions of SQL Server, including SQL Server Express, regardless of whether you use SQL Server Management Studio or SQL Server Management Studio Express.
IMPORTANT: In ePO 5.10 and later, threat event information has been split into its own database, so it is required to back up both databases. Carry out the backup process on both the main database (default name ePO_<ePO_server_name>) and the events database (default name ePO_<ePO_server_name>_Events).
  1.  Open SQL Server Management Studio.
  2. Type the logon and password information for the account specified and click Connect.
  3. Expand Databases.
  4. Right-click the ePO database, where the default name is ePO_<ePO_server_name>, and select Tasks, Back Up.
  5. In the Database drop-down field, select the ePO_<ePO_server_name> database to be backed up.
  6. In the Backup type drop-down field, click Full.
  7. In the Name field, type a name for the backup set (for example, ePO Master Backup).
  8. In the Description field, type a description of the backup (for example, ePO Full Backup).
  9. In the Destination section, if a backup set exists and is listed in the Back up to field, select it and click Remove.
  10. Click Add, select the File name entry, type the full path to the backup file (for example, e:\DATA\ BACKUPS\ePO.BAK), and click OK.
  11. In the Select a page section on the left pane, click Options.
  12. Under Reliability, select Verify backup when finished.
  13. In the Set backup compression drop-down field, select Compress backup.

    NOTES:
    • The Set Backup Compression option is available only in SQL Server 2008 Enterprise Edition and later versions of SQL Server.
    • Backup compression is not supported with SQL Server Express Edition.
       
  14. Click OK.

Solution

To restore an ePO database using SQL Server Management Studio:

NOTE: The steps in this article apply to all editions of SQL Server, including SQL Server Express, regardless of whether you use SQL Server Management Studio or SQL Server Management Studio Express.

IMPORTANT: In ePO 5.10 and later, threat event information has been split into its own database, so it is required to restore both databases. Carry out the restore process on both the main database and the events database.
  1. Open SQL Server Management Studio.
  2. Type the logon and password information for the account specified and click Connect.
  3. Expand Databases.
  4. Right-click the ePO database where the default name is ePO_<ePO_server_name> and select Tasks, Restore, Database.
  5. In the Destination for Restore section, for the To database drop-down field, type the name of the database.
     
    • If you want to restore from backup and overwrite the existing ePO database, select the database name (for example, ePO_<ePO_server_name>).
    • If you want to retain your existing ePO database and restore the backup with a new name, for example, if you would like to compare them, provide a different name, such as ePO_<ePO_server_name>_New. This action restores the backup to a new database using the supplied name.

      IMPORTANT: When you restore the ePO 5.10 events database, you must keep it the same original name because it is linked to the main ePO database by a synonym. When you restore the database by any other name than the original, that link is broken.
       
  6. Select the From device option under Source for restore and click the ellipsis (...).
  7. Click Add in the Specify Backup window.
  8. In the Locate Backup File window, navigate to the backup file (for example, C:\Backup\Full_backup_20150630_epo.bak) and click OK.
  9. Select the checkbox in the Restore column for the Select the backup sets to restore and select the backup set to restore.

    NOTE: If you have more than one backup in the chosen media set, choose the backup set you want to restore by selecting it from the list of backup sets. (If you have more than one backup, it is usually the .bak file.)
     
  10. Click Options in the Select a page section on the left pane.
  11. If you are restoring over an existing ePO database as in step 5 above, Under Restore options, select Overwrite the existing database (WITH REPLACE).
    NOTE: You might need to stop the ePO services and close any open connections to the ePO database before you can restore over it.
     
  12. Click OK.

Previous Document ID

614733

Rate this document

Glossary of Technical Terms


 Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.