12.1.2 Backing up and restoring the asset management database
This subsection describes how to back up and restore the asset management database.
Notes
-
Before you start this procedure, stop all Asset Console services, commands, and tasks.
-
Stop the Asset Console services in the following order:
-
World Wide Web Publishing Service or World Wide Web Publishing
-
Asset Console commands and tasks
When you run Asset Console after having backed up or restored the asset management database, start the services in the reverse of the order in which they were stopped.
Before you execute the operation, log in as a user with administrator permissions.
-
-
After the restore processing is completed, execute the command for acquiring JP1/IT Desktop Management 2 - Manager management information (jamTakeITDM2Info.exe -ALL) if necessary. If you do not perform this, the data in the database might not match the data in JP1/IT Desktop Management 2 - Manager.
There are two ways to back up the asset management database:
-
By using the Database Manager dialog box
-
By executing jamemb_backup.bat from the command line
To back up and restore the asset management database using the Database Manager dialog box:
-
Click the Start button and point to Programs, then to JP1_IT Desktop Management 2 - Asset Console, and then select Setup.
The Setup dialog box appears.
-
Click the Database Manager icon.
The following Database Manager dialog box appears.
Figure 12‒3: Database Manager dialog box -
Select the task that you want to execute and then click the Next button.
For details about how to back up and restore the asset management database, see (1) and (3).
The method for backing up the asset management database using the command is described in (2).
- Organization of this subsection
(1) Backing up the asset management database from the Database Manager dialog box
To back up the asset management database:
-
In the Database Manager dialog box, select Back up Embedded RDB and then click the Next button.
The dialog box for acquiring a backup of the database is displayed as shown below. Logs displays a maximum of 10 backup logs.
Figure 12‒4: Dialog box for acquiring a backup of the database -
Specify the name of the backup file.
In Backup file name, specify the name of the backup file. Clicking the ... button displays a dialog box in which you can browse files and specify a desired file. Specify 1 to 255 bytes of characters. Note that ", |, *, <, >, ?, &, ^, and / are not permitted. By default, Asset-Console-installation-folder\db\backup.dat is specified.
By clicking a backup log displayed in Logs, you can specify the file path of the selected backup log.
- Note
-
When data backup is executed, the contents of the asset management database are stored in the backup file. Therefore, specify a file in a folder on the drive that has sufficient free space.
-
Enter a comment, if necessary.
If there is additional information about the backup file, enter a maximum of 64 bytes of characters in Comment.
-
Click the Execute button.
The asset management database is backed up. When the backup processing is completed, a message to that effect is displayed and the database manager is terminated.
If the backup processing fails, a message to that effect is displayed. Click the Show Maintenance Information button to check the execution result.
(2) Backing up the asset management database using commands
This subsection gives the function, format, options, return value, notes about command execution, and an execution example of jamemb_backup.bat, which is used to acquire a backup file of the asset management database.
jamemb_backup.bat is stored in the following folder:
Asset-Console-installation-folder\exe
(a) Function
This command backs up the asset management database.
(b) Format
jamemb_backup.bat -b backup-file-path -o result-file-path [-y]
(c) Options
- -b backup-file-path
-
Specifies the full path of the file for which the backup is to be acquired. Specification of this option is mandatory.
- -o result-file-path
-
Specifies the full path of the file to which the execution results are to be output. Specification of this option is mandatory.
- -y
-
If this option is specified, the command starts the backup processing without waiting for a key response.
If this option is omitted, the command waits for a key response. To cancel execution, press the Ctrl + C keys.
(d) Return value
Returns one of the following return values:
Return value |
Description |
---|---|
0 |
Normal termination. You can check the result file for the backup details. |
11 |
Invalid option format. |
101 or greater |
Terminated with another error. |
(e) Notes on command execution
Execute jamemb_backup.bat as a user with administrator permissions.
(f) Execution example
jamemb_backup.bat -b C:\temp\backup\Backup.dat -o C:\temp\backup\kekka.log -y
(3) Restoring the asset management database from the Database Manager dialog box
To restore the asset management database from a backup file:
-
In the Database Manager dialog box, select Restore Embedded RDB and then click the Next button.
The dialog box for restoring the database from its backup file is displayed as shown below. Logs displays a maximum of 10 backup logs.
Figure 12‒5: Dialog box for restoring the database from its backup file -
Specify the name of the backup file.
In Backup file name, specify the name of the backup file that is to be restored. Clicking the ... button displays a dialog box in which you can browse files and specify a desired file. Specify 1 to 255 bytes of characters. Note that ", |, *, <, >, ?, &, ^, and / are not permitted. By default, the file name specified in Backup file name during backup acquisition is specified. If you have changed the location of the backup file after backup processing, use the ... button to specify the correct file name.
By clicking a backup log displayed in Logs, you can specify the file path of the selected backup log.
-
Click the Execute button.
The asset management database is restored from its backup file. When the restore processing is completed, a message to that effect is displayed and the database manager is terminated.
If the restore processing fails, a message to that effect is displayed. Click the Show Maintenance Information button to check the execution result.
- Note
-
To restore a backup file, Asset Console must have been installed at the same path as when its backup was acquired. Before starting the restore processing, make sure that the installation folder has the same path as when the backup was acquired.