Job Management Partner 1/Software Distribution Setup Guide

[Contents][Glossary][Index][Back][Next]

7.4.5 Recovering the database from a backup

Notes
  • The database into which the data is to be restored must be in the same environment as the database from which the backup was made.
  • The backup files acquired prior to database upgrading cannot be restored because the database structure is different. After upgrading the database, acquire a backup again.
  • If you use the Operation Log List window, it may take time to restore the database depending on the size of the managed operation log information.
  • Before you restore the database, stop Remote Install Server by opening Control Panel, and then choosing Administrative Tools, and Services.
  • If you are using Asset Information Manager Subset, stop the Asset Information Manager Subset services in the following order.
    1. World Wide Web Publishing Service or World Wide Web Publishing
    2. Commands and tasks of the Asset Information Synchronous Service and Asset Information Manager Subset
    3. JP1/Client Security Control - Manager (applicable if JP1/CSC is linked)
    To use Asset Information Manager Subset after you have used the Database Manager, start the services in the reverse order from that listed above.
  • If a connection pool has been set up in the ODBC database, the connected status will not change from the time that the Asset Information Manager Subset job was stopped until the timeout time set in the connection pool elapses. Therefore, wait for the connected status to change before restoring the database from the backup.

The procedure for restoring data from a backup file, created by Database Manager or by a netmdb_backup.bat command, to the Embedded RDB used by JP1/Software Distribution is outlined below.

To recover the database from a backup:

  1. In the Welcome dialog box, select Recover the database from backup, and then click the Next button.
    The Authentication Information of Database dialog box appears.
  2. In the Authentication Information of Database dialog box, specify the password and then click the Next button.
    The Restore Database dialog box appears.

    Figure 7-19 Restore Database dialog box

    [Figure]

    Backup file path
    Specifies the backup file to be used to restore the database. Note that if the OS being used is a 64-bit version of Windows Server 2012, Windows Server 2008 or Windows Server 2003 (x64), a backup file under the %Systemroot%\system32 directory cannot be specified.
  3. In the Restore Database dialog box, specify the backup file and then click the Next button.
    The Execute Restore Database dialog box appears.

    Figure 7-20 Execute Restore Database dialog box

    [Figure]

  4. Click the Execute button.
    The database is restored.