sdmimportdb (restoring backup data)
This command restores data owned by the smart device manager to the state at the last backup point.
- Organization of this page
Functionality
This command restores data owned by the smart device manager to the state of the last backup point in case a disk failure occurs. To restore data, a backup file acquired with the sdmexportdb command is used.
Execute this command on the smart device manager.
Format
sdmimportdb[ -f backup-folder]
Arguments
- -f backup-folder
-
Specify the absolute path to the folder in which the backup file of the target restore point resides. The path must contain the folder name yyyyMMddhhmmss that is created in the backup folder by the sdmexportdb command. Only a folder in a local drive can be specified.
To specify a path containing a space, enclose the strings with double quotation marks (").
Make sure that the path length of the backup folder is 165 or fewer characters (bytes), including the backup file name.
Half-width alphanumeric characters, white space, and the following special characters are allowed:
#, (, ), -(hyphen),.(period), @, _, and path-delimiter backslash (\)
When this argument is specified, the backup folder specified in the argument is used.
When this argument is omitted, the most up-to-date backup folder available under the path below is chosen by name.
JP1/ITDM2 - SDM (Smart Device Manager)-installation-folder\mgr\backup
- Example:
-
If the following backup folders are under the path, the \20140101060000 folder is used to restore data:
\20140101000000
\20140101060000
Storage location
JP1/ITDM2 - SDM (Smart Device Manager)-installation-folder\mgr\bin
Execution permissions
Administrator permissions (this command is executed from the administrator's console if the Windows UAC function is enabled)
Notes
-
To execute this command, the smart device manager and communication server must be stopped.
-
To execute this command, the database service on the smart device manager must be running.
-
Multiple instances of this command cannot be executed simultaneously.
-
This command cannot be executed simultaneously with any of the following commands:
-
sdmexportdb
-
Commands beginning with sdmioutils
-
Return values
Return value |
Description |
---|---|
0 |
The command finished normally. |
11 |
The format for specifying the command arguments is invalid. Alternatively, the length of the folder name specified for the command argument exceeds the upper limit. |
12 |
You do not have the permissions to execute this command. |
13 |
The specified server is not correct, or the operating environment of JP1/ITDM2 - SDM (Smart Device Manager) is invalid. |
14 |
The file does not exist, or you do not have permission to access it. |
15 |
A file access error occurred, or the disk does not have sufficient capacity. |
16 |
The specified folder does not exist. |
17 |
An access error for the specified folder occurred. |
18 |
Another command is being executed. |
25 |
An attempt to restore the database failed. |
30 |
The database cannot be accessed. |
150 |
Other error occurred. |
253 |
The service has not started. |
Example
The following shows an example of using the command to restore data from a backup acquired at 2:30:00 on January 1, 2014 (backup folder: C:\tmp\backup\20140101023000).
sdmimportdb -f C:\tmp\backup\20140101023000
Related Topics