Jump to content English
hp.com home
HP Systems Insight Manager  |  Administering the Software  |  Backing Up and Restoring the Database  |  Windows

Backing Up and Restoring the Database
Windows

» HP Systems Insight Manager

»Table of Contents
»Index
»Product Overview
»Getting Started
»Monitoring Systems, Events, and Clusters
»Using Tasks
»Using Default Tools
»Reporting
»Administering the Software
»Users and Authorizations
»Users
»Backing Up and Restoring the Database
»HP-UX/Linux
Windows
»Toolboxes
»System Groups
»Authorizations
»Managed Systems
»Audit Log
»Clusters
»Events
»Networking and Security
»Server Certificates
»Trusted Certificates
»Identification
»Filtering
»Discovery
»Status Polling
»Data Collection
»Protocols
»WMI Mapper Proxy
»Manage System Types
»Version Control Repository
»Troubleshooting
»Printable Version
»Glossary
»Using Help
Content starts here
» Introduction
» Backing up a SQL Server Database
» Restoring the SQL Server Database From a Backup
» Backing Up a MSDE Database
» Backing up HP Systems Insight Manager Using MSDE command line features
» Related Procedure
» Related Topic

Introduction

A Microsoft SQL Server database or MSDE is used by HP Systems Insight Manager to store all collected information about the systems on your network as well as all configuration options. Always back up your database using an appropriate backup schedule. In the event of a catastrophic database problem, this backup can be restored to return HP Systems Insight Manager to operation.

If you must restore your database, you must stop the HP Systems Insight Manager Service from the Services applet before doing the restore. After the restore is complete, restart the service.

If you must reinstall HP Systems Insight Manager but wish to preserve the information in your database, you must have a backup of your database. After reinstalling HP Systems Insight Manager, you can restore your previous database backup into the database created during the HP Systems Insight Manager installation.

Backing up a SQL Server Database

Microsoft SQL Enterprise Manager has built in utilities to permit the database to be backed up. The backups can be automated if desired. It is also recommended to view the help provided directly with SQL Enterprise Manager to gain a complete understanding of this procedure.

To backup the HP Systems Insight Manager database using Microsoft SQL Enterprise Manager:

  1. Log out of HP Systems Insight Manager and stop the HP Systems Insight Manager Service.

  2. Backup the configuration sub-directory name config where HP Systems Insight Manager is installed.

    Note: Use any tools that you are familiar with to back up a directory for this process. For example, you could use Windows Explorer to make a copy of the HP Systems Insight Manager installation directory.

  3. Open Microsoft SQL Enterprise Manager using the Start Menu from a Windows console.

  4. In the tree displayed on the left-hand side, expand the Microsoft SQL Servers branch and SQL server group. If the server where the HP Systems Insight Manager database is located is not listed, add it by selecting new SQL Server Registration from the right click menu.

  5. Select the server where the HP Systems Insight Manager database is located. From the tools menu at the top, select Backup database. In the dialog that appears, select the database named Insight_v1_0 and make sure that “Database-complete” is selected as the backup option.

  6. Click [Add] in the destination and select a location to backup the database. For example, a disk or tape.

  7. Click [OK] to initiate the backup.

Restoring the SQL Server Database From a Backup

  1. Open Microsoft SQL Enterprise Manager using the Start Menu from a Windows console.

  2. In the tree displayed on the left-hand side, expand the Microsoft SQL Servers branch and SQL server group. If the server where the HP Systems Insight Manager database is located is not listed, add it by selecting New SQL Server Registration from the right click menu.

  3. Select the server where the HP Systems Insight Manager database is located. From the right-click menu at the top, select All Tasks > Import Data.

    The DTS Import/Export Wizard launches. Click [Next].

  4. In the Server field, select the server where your Exported database exists. Select the mode of Authentication as Windows Only.

  5. Select the name of the restored database from the Database drop-down menu . For example, Insight_v1_0.

  6. Click [Next].

  7. Select your HP Systems Insight Manager system from the Server drop-down menu. Select the mode of Authentication as Windows Only. Select Insight_v1_0 from the Database drop-down menu. Click [Next].

  8. Select Copy table(s) and view(s) from the source database. Click [Next].

  9. Click Select All button in the Select Source Tables and Views screen. Click Next.

  10. Select Run Immediately . Click [Next].

  11. Click [Finish].

  12. Click [Done].

  13. Restore the configuration sub-directory, named config where HP Systems Insight Manager is installed.

  14. Start the HP Systems Insight Manager service.

Backing Up a MSDE Database

With MSDE, you can back up both data files and transaction logs. In the event of a failure, the most recent database backup is restored. Once the restore is complete, you can apply the changes contained in all of the subsequent transaction log files, and the database is brought back to the state it existed when the last nightly transaction log was backed up.

If you have Access 2000, you can use the BACKUP command in the Database Utilities menu of an Access project to back up an MSDE database. If SQL Client Tools are installed, you can use SQL Enterprise Manager to back up an MSDE database.

The SQL Client Tools and Access 2000 are not part of the Microsoft Data Engine (MSDE) install. Therefore, if you only have MSDE installed, you do not have the above options. In order to back up an MSDE database, you can use the TSQL BACKUP DATABASE command and execute with Osql.exe (command line Query tool) as demonstrated below. This procedure applies to Microsoft Data Engine (MSDE) version 1.0. For information on all of the stored procedures used below, refer to the SQL Books Online.

Backing up HP Systems Insight Manager Using MSDE command line features

  1. Logout of HP Systems Insight Manager and stop the HP Systems Insight Manager service.

  2. Backup the configuration sub-directory name config where HP Systems Insight Manager is installed.

    Note: Use any tools that you are familiar with to back up a directory for this process. For example, you could use Windows Explorer to make a copy of the HP Systems Insight Manager installation directory.

  3. The code below is an example of how to use the various stored procedures with MSDE to perform a backup. This code does not back up your mission critical database "as is" and might require some modification to run in your environment, such as changing your database name, server name, and so forth. Paste the following TSQL script in Notepad and save it to a file called myBackup.sql:

    --This TSQL script creates a backup job and calls sp_start_job to run the job.

    --Create job.

    --You may specify an e-mail address, commented below, and/or pager, etc.

    --For more details on this option or others, reference SQL Books Online.

    USE msdb

    EXEC sp_add_job @job_name = 'mydbBackupJob',

    @enabled = 1,

    @description = 'mydbBackupJob',

    @owner_login_name = 'sa',

    @notify_level_eventlog = 2,

    @notify_level_email = 2,

    @notify_level_netsend =2,

    @notify_level_page = 2

    -- @notify_email_operator_name = 'email name'

    go

    -- Add job step (backup data).

    USE msdb

    EXEC sp_add_jobstep @job_name = 'mydbBackupJob',

    @step_name = 'Backup INSIGHT Data',

    @subsystem = 'TSQL',

    @command = 'BACKUP DATABASE INSIGHT_V1_0 TO DISK = ''c:\INSIGHT.dat_bak''',

    @on_success_action = 3,

    @retry_attempts = 5,

    @retry_interval = 5

    go

    -- Add job step (backup log).

    USE msdb

    EXEC sp_add_jobstep @job_name = 'mydbBackupJob',

    @step_name = 'Backup INSIGHT Log',

    @subsystem = 'TSQL',

    @command = 'BACKUP LOG INSIGHT_V1_0 TO DISK' = 'c:\INSIGHT.log_bak''',

    @on_success_action = 1,

    @retry_attempts = 5,

    @retry_interval = 5

    go

    --Add the target servers.

    USE msdb

    EXEC sp_add_jobserver @job_name = 'mydbBackupJob', @server_name = N'(local)'

    -- Run job. Starts the job immediately.

    USE msdb

    EXEC sp_start_job @job_name = 'mydbBackupJob'

    -- The file has to be copied under /mssql/binn folder

    -- The command to execute it is OSQL -S mysqlserver -U sa -P password if any -i mybackup.sql -n

Related Procedure

» Backing Up and Restoring the Database - HP-UX/Linux

Related Topic

» Administering the Software - Backing Up and Restoring the Database