11.2.14 Backup procedure when the Item storage database is used
When you perform yearly maintenance for the Item storage database, you need to back up both the Item management database and the Item storage database after maintenance.
To back up the Item management database and the Item storage database:
-
Stop services in the following order:
-
JP1/Service Support - Task Service service
-
JP1/Service Support - Web Service service
-
JP1/Service Support service
Do not stop JP1/Service Support - DB Server service.
-
-
From the Start menu, select Programs, JP1_Service Support, and then JP1_SS Command Prompt.
-
Execute the jssdbbackup.bat command.
Execute the jssdbbackup.bat command to back up the Item management database and the Item storage database. Specify the -o and -maint options as arguments. For details about the jssdbbackup.bat command, see jssdbbackup.bat (backs up databases) in Chapter 12. Commands.
Note that if you specify the -o option, the command outputs information about the storage directories of the Item management database and Item storage database when they were backed up. This information is stored in the dbpath.txt file in the backup output directory. You need dbpath.txt to recover the Item storage database. Information output to dbpath.txt includes option information specified when the databases were backed up, the size of the Item management database that was backed up, and the folder where the Item storage database was expanded. This information is the same as the information that is output when the jssdbstatchk.bat command is executed with the -dbpath option specified.
- Note
-
To back up only the Item storage database, you can execute the jssdbbackup.bat command while the services are running. If the backup requires a long time, you can first back up the Item management database, start the services, and then back up the Item storage database while JP1/Service Support is running. For details about the jssdbbackup.bat command, see jssdbbackup.bat (backs up databases) in Chapter 12. Commands.