Dell EMC OpenManage Essentials Version 2.5 User's Guide

Restoring the OpenManage Essentials Database

Before you begin to restore the OpenManage Essentials database:
  • Ensure that OpenManage Essentials database back up file, OMEssentials.bak, is available on the system. If required, you must copy and paste the OpenManage Essentials database back up file from the system where you created the back up file.
  • Ensure that Microsoft SQL Server Management Studio is installed on the system.
  • Ensure that you have sysadmin access for SQL Server.
To restore the OpenManage Essentials database:
  1. Open SQL Server Management Studio on the system where you want to restore the OpenManage Essentials database.
  2. In Object Explorer, right-click Databases > Restore Database . The Restore Database window is displayed
  3. Under Source, select Device and click the browse button. The Select backup devices window is displayed.
  4. Click Add and then browse to select the OpenManage Essentials database back up file.
  5. Click OK to close the Select backup devices window.
  6. Click OK in the Restore Database window to start restoring the database.
A confirmation message is displayed after the database is restored. The restored OMEssentials database is displayed under Databases in Object Explorer.
  • NOTE: The database restoration may not be successful if multiple instances of the backup file, OMEssentials.bak, are available on the system. To resolve the issue, rename both the files ( OMEssentials and OMEssentials_log) in the Restore database file as section of the Restore Database window, and then try restoring the database.

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\