Backing up and restoring HP Systems Insight Manager 7.x or greater data files in a Windows environment

White paper | HP Systems Insight Manager 7.x
5 | March 2013
Saving and restoring data
files
HP SIM can use one of the following databases on a system that is running the Microsoft Windows
operating system:
Microsoft SQL Server Database Engine
Microsoft SQL Server 2008
Microsoft SQL Server 2008 R2 Express
Oracle database
Saving and restoring files where HP SIM is installed using a
Microsoft SQL database (2008 Express/2008 Standard)
This section explains how to save (back up) and restore files used with a Microsoft SQL database.
Notes:
HP recommends stopping the HP SIM service to ensure that discovery and data processes do
not occur during the save. However, with two new commands, mxquiesce and
mxunquiesce, you can leave the HP SIM service running during the save. These commands
pause and resume the system; they do not perform backup.
The mxquiesce command can be used to allow in-progress, critical tasks to complete, and to
block new tasks from starting. When the system is quiesced, noncritical tasks are canceled. CLI
commands and SOAP calls that modify the state of HP SIM cannot be executed when the
mxquiesce command is executed. In order to perform a clean backup of HP SIM, no tasks
should be running when the HP SIM services are stopped.
The mxunquiesce command returns the system to the original state, enabling the user to
create, modify, and delete tasks, as well as execute CLI commands and SOAP calls.
The mxquiesce and mxunquiesce commands are located in <SIM>\bin. Only an
administrator with HP SIM Administrator privileges can execute these commands.
mxquiesce –u Administrator –p <password>
mxunquiesce –u Administrator –p <password>
If the mxquiesce command detects that a component has taken longer than the specified
timeout to complete the quiesce operation, the mxquiesce command will stop the quiesce
operation and return in the unquiesced state. The mxquiesce command can be run again to
retry the quiesce operation.
If the mxquiesce command encounters an error, it will exit in the unquiesced state.
The mxquiesce and mxunquiesce commands are mutually exclusive; they should not be
run simultaneously. HP recommends running the mxunquiesce command after the backup
so that the CMS returns to a fully unquiesced state.