Backing up an msde database – HP Systems Insight Manager User Manual
Page 522
![background image](/manuals/397204/522/background.png)
3.
Reinstall any backed up custom files (TDEFs, MIBs, sign in prompt, and other actions) under the HP SIM
directory tree.
4.
Reinstall any backed up custom support packs used by VCRM.
Note: The HP SIM installation procedure includes loading VCRM on the Windows Central Management
Server (CMS).
5.
Reinstall any plug-in utilities (and associated files) used with HP SIM.
6.
Stop the HP SIM Service if it is running, along with any HP SIM plug-in applications such as HP ProLiant
Essentials Performance Management Pack.
7.
Using the file management tool of your choice, restore the directories and files listed below:
Note: For each occurrence of
offered, make sure that the Always replace the file on disk option is selected.
Note: A tool that preserves file permissions (such as the Windows Backup tool) must be used while
saving directories and files.
Description
Directory of file
Directory of configuration files
Shared OpenSSL certificate directory
hp/sslshare/
Audit file
Program updates (required if HP SIM is to be reinstalled)
Certificate used by the Command Line Interface (CLI)
bin/servercert.pem
CLI configuration file
bin/cliclientconfig.cfg
(if existing)
(if existing)
(optional) Contains job result output
8.
From the Windows Start menu on a Windows console, open Microsoft SQL Enterprise Manager.
9.
In the tree displayed in the left panel, expand the Microsoft SQL Servers branch and SQL Database.
The Restore Database box appears.
10. From the Restore as Database dropdown list, select the name of the restored HP SIM database (such
as Insight_v*) and select Database as the type of Restore.
11. From the Show backups of database dropdown list, select the backup set to be used, and click OK.
The database will be restored, with a dialog box indicating the progress.
12. Ensure that the directory config is copied to the configuration subdirectory where HP SIM is installed.
13. Open the command line window and enter mxconfigrepo -c to check for database errors. Use the
command mxconfigrepo -f to fix any errors, and run the command mxconfigrepo -c once
again as a final check.
14. Start the HP SIM service and any plug-in applications.
Backing up an MSDE database
Microsoft Data Engine (MSDE) allows backup up of both data files and transaction logs. In the event of a
failure, the most recent database backup is restored. When the restore is complete, the changes contained
in all subsequent transaction log files can be applied to bring the database back to the state it existed when
the last nightly transaction log was backed up previous to the failure.
For backing up an MSDE database, Microsoft Access 2000 includes the BACKUP command in the Database
Utilities
menu of an Access project. If SQL Client Tools are installed, you can use SQL Enterprise Manager
to back up an MSDE database.
NOTE:
HP recommends stopping the HP SIM service to ensure that the discovery and data collection
processes do not occur during the save. However, the HP SIM service can be left to run during the save
522 Administering systems and events