8.1.2 Backing up the database
A command is used to back up a database.
This subsection explains how to back up a database.
We recommend that you back up your database periodically.
- Organization of this subsection
(1) Before you start
Verify that setup of SLM - Manager and SLM - UR has been completed.
For details about how to set up SLM - Manager, see 5.1.6 Setting up SLM - Manager; for details about how to set up SLM - UR, see 5.1.7 Setting up SLM - UR.
(2) Procedure
To back up the database:
Terminate all SLM - URs that are connect to the SLM - Manager whose database is to be backed up.
For details about how to terminate SLM - UR, see 2.1.3 Terminating SLM - UR.
On the host on which the SLM - Manager whose database is to be backed up is installed, from the Windows Start menu, select Administrative Tools, and then Services.
Stop the SLM - Manager service SLM - Manager Web Service (service name: JP1_ITSLM_MGR_Web_Service) of the SLM - Manager whose database is to be backed up.
Stop the SLM - Manager service SLM - Manager Service (service name: JP1_ITSLM_MGR_Service) of the SLM - Manager whose database is to be backed up.
Execute the database backup command.
Execute the following backup command:
jslmdbcopy absolute-path-of-backup-file
For details about the backup command, see 9.4 jslmdbcopy (backs up database) in 9. Commands.
Start the SLM - Manager service SLM - Manager Service that was stopped in step 4.
Start the SLM - Manager service SLM - Manager Web Service that was stopped in step 3.
Start all SLM - URs that were terminated in step 1.
For details about how to start SLM - UR, see 2.1.2 Starting SLM - UR.
If the database backup command terminates normally and SLM - Manager and the SLM - URs start, the task of backing up the database is complete.
(3) Supplementary information
If you cannot end the SLM - Manager service in a short cycle, as shown in the following operation example, we recommend using a combination of the database backup command and the export command of monitor information to back up the database:
-
Back up the database by using the jslmdbcopy command every month.
-
Back up the database by using the jslmmgrexport command (by specifying the argument -t 7) every week.
If data stored in the product goes missing due to, for example, a system failure, perform the following procedure to restore the data:
-
Stop the monitoring of the monitoring target services.
-
Stop the following services:
-
SLM - Manager Service (service name: JP1_ITSLM_MGR_Service)
-
SLM - Manager Web Service (service name: JP1_ITSLM_MGR_Web_Service)
-
-
Use the jslmdbrstr command to restore the file output by the recently executed jslmdbcopy command.
-
Start the services that were stopped in step 2.
-
Use the jslmmgrimport command to chronologically import the files that were output by the jslmmgrexport command, beginning with the first files output after the most recent execution of the jslmdbcopy command.
-
Start monitoring the monitoring target services.