topic Re: HPSIM Backup in Server Management - Systems Insight Manager

HPSIM Backup

Jose Antonio_5 — Mon, 31 Jul 2006 04:05:59 GMT

Hi,
I´m a new HPSIM user. I have to make a periodic HPSIM backup, but I don´t know what files, tables,... Can anybody help me?

Re: HPSIM Backup

Bill Slobodnik — Mon, 31 Jul 2006 08:18:51 GMT

If your using a full version SQL Database, backing up the Insight database should suffice if your just concerned with HPSIM backup and not a full server.
I have a DR session of HPSIM set up with a DR SQL server as well. Copying/restoring the Insight database to the backup server and pointing the HPSIM DR session to that DB by editing the Database.props file to point to the DR SQL server will allow a complete DR solution.

Re: HPSIM Backup

Jose Antonio_5 — Tue, 01 Aug 2006 01:27:48 GMT

Hi,
IÂ´m sorry. IÂ´m using MSDE...

Re: HPSIM Backup

MsCindy — Wed, 30 Aug 2006 09:11:47 GMT

The link below has the steps in it to back up your HPSIM database when it is a MSDE database. The only bad thing is that you have to shut down HPSIM when doing it.
http://www.hp.com/wwsolutions/misc/hpsim-helpfiles/mxhelp/mxportal/en/admin_ref_dbBackup_windows.html

Hope that helps!

Re: HPSIM Backup

Jose Antonio_5 — Thu, 31 Aug 2006 02:30:55 GMT

Hi, thanks for your reply.
I have made the backup yesterday, and I have saw that itÂ´s not necesary stop services (when we made a restore yes, but when we made a backup, it seems, it not necesary). Are you agree??
Thanks, Jose.

Re: HPSIM Backup

MsCindy — Thu, 31 Aug 2006 08:08:01 GMT

Sorry, I must have been incorrect when stating you had to stop the services to perform a backup. It has been some time since I did a MSDE backup because we have switched to a SQL database.

Glad the article helped!

Re: HPSIM Backup

sandeep_raman — Thu, 31 Aug 2006 08:55:34 GMT

Hello Jose,

You are correct.
Restoring files for use with MSDE
Microsoft Access 2000 includes the RESTORE command in the Database Utilities menu of an Access project for restoring an MSDE database. If SQL Client Tools are installed, SQL Enterprise Manager can also be used to restore an MSDE database. To restore the data files for MSDE use, perform the following procedure.
1. If HP SIM is running, stop the HP SIM service and any HP SIM plug-in applications, such as HP Performance Management Pack.

SRH