The restoration function provided by the product carries the following Restoration Tool.
Set the restoration conditions on the GUI before restoring data.
The Restoration Tool can restore the data that is backed up through the following two methods:
Backup Tool
Backup commands
Data backed up using older versions of Management Server and Master Management Server can also be restored.
The following data can be restored by the Restoration Tool:
Management information
Log information (log data in the database and command logs)
For details about the data to be restored, refer to "3.1.1.2 User Assets".
In addition, the time required by data restoration can be estimated according to the number of logs to be restored. The estimation is as follows:
5,000 per second (Xeon, 2.0 GHz, 2 GB memory, and RAID1 architecture)
Note: More time may be consumed, depending on the server performance and RAID architecture.
The operational status of the Restoration Tool will be output to event logs.
DTKTBLRESTOR (restore database command) is used to execute a restore for the Log Viewing Database, however, it cannot be used for the Operation Database.
This command is used to restore the iOS management database. Refer to "swss_MDMDB_RESTORE.exe (Restore iOS Management Database)" in the Systemwalker Desktop Keeper Reference Manual.
The restore iOS management database command allows you to restore backed up iOS management databases, using the following feature:
DTKMSTB.EXE (backup of management information)
The operational status of the restore iOS management database command is output to a log file.
Note
If Systemwalker Desktop Keeper and Systemwalker Desktop Patrol coexist, use SDSVSetMS.EXE (change configuration of Smart Device Relay Server command) to check the host name of the iOS management database connected to the Smart Device Relay Server. Restore the data that was backed up on the server that matches with the iOS management database host name displayed in "iOSmgr.h" in the server that matches with the host name displayed in "iOSmgr.h".
This section describes how to restore data from the database by using the Restoration Tool provided by the Systemwalker Desktop Keeper.
Note
Notes on using the Restoration Tool
When the Management Server or Master Management Server is running, do not restore the "management information". If the "management information" is overwritten, it may result in incomplete "management information" and "log information".
These settings cannot be backed up by the Backup Tool (GUI) or backup commands. Therefore, re-set these settings after the Restoration Tool restores the database.
After the management information is restored, the old information is overwritten. Note that the difference between the old information and the restored information will not be displayed.
When adding and restoring the log information in the environment where log information already exists, index information will be created after restoration; therefore, restoration will take more time. (It is three times as long as the time used by log information restoration in the environment where there are no logs.)
In the Restoration Tool, inconsistent management information is deleted, which may result in a difference between the number of records during backup and the number of records during a restore.
When managing iOS devices, restore the data backed up in the same period so as to avoid inconsistencies between the Operation Database and iOS management database.
Refer to "swss_MDMDB_RESTORE.exe (Restore iOS Management Database)" in the Systemwalker Desktop Keeper Reference Manual for details on how to use the restore iOS management database command.
Point
Logon history
The logon history will be output to event logs (application).
Restore the Database in Use
The procedure for using the Restoration Tool is as follows:
When managing Android or iOS devices, use SDSVService.bat (start/stop service of Smart Device Relay Server command) to stop the service of the Smart Device Relay Server. Refer to "SDSVService.bat (Start/Stop Service of Smart Device Relay Server)" in the Systemwalker Desktop Keeper Reference Manual for details on the command.
Log on the Windows OS as a user of the Administrators group or Domain Admins group. If there is another running application, exit it.
Reconfigure the following settings information of the Server Settings Tool that you took note of when executing the backup.
System settings
Active Directory linkage settings Note: When using the Active Directory linkage feature
Administrator notification settings
Management Server settings
Trace settings
Folder / CT self version upgrade settings
Refer to "2.3.6 Set Environment of Management Server/Master Management Server" for details on how to display each window of the Server Settings Tool.
Select All Programs > Systemwalker Desktop Keeper > Server > Restoration Tool from the Start/Apps menu on the PC installed with the Management Server or Master Management Server.
The Restoration Tool window is displayed. Click Yes to confirm restoration in the running database.
The Systemwalker Desktop Keeper - Operation Database Restoration Tool window is displayed.
Log in by using the user ID (granted with the authority to back up and restore information) registered in the Server Settings Tool. (The user ID and password of the Primary Administrator can also be used for login.)
Click OK.
The Operation Database Restoration Tool window is displayed.
The following table describes the menu bar in the Operation Database Restoration Tool window.
Menu Bar | Function Summary | ||
|---|---|---|---|
File | Exit | Exit the Restoration Tool. | |
Service | Confirm Service Status | Display the operational status of the "Level Control Service" and "Server Service" on the target server. | |
Start Service | Start the "Level Control Service" and "Server Service" on the target server. | ||
Stop Service | Stop the "Level Control Service" and "Server Service" on the target server. | ||
Settings | Trace Restoration Tool | No | Do not collect the traces of the Restoration Tool. |
Summary | Collect the traces of the Restoration Tool in summary mode. | ||
Details | Collect the traces of the Restoration Tool in details mode. | ||
Help | Online Help | Display the online help manual. | |
Version Information | Display the copyright information and version information. | ||
Before restoring the "management information" and "log information" by using the Restoration Tool, it is necessary to stop the "Level Control Service" and "Server Service" on the target server. Select Stop Service from the Service menu. A confirmation window is displayed. Click OK in the window to stop the services.
The operation result window is displayed. Click OK in the window.
In the Restoration Tool of database for viewing logs window, enter the information described in steps 1 and 2, common setting information, and working folder information.
Item Name | Description |
|---|---|
Restore management information | Select this when restoring the management information. |
Folder for viewing restoration files | Specify the folder that saves the files used for restoration. (Specify the folder that contains the LEVELTARGET.csv and LEVELCOMPOSITION.csv files backing up the management information.) There are two methods for specifying such a folder:
An absolute path can contain a maximum of 189 single-byte characters (94 fullwidth characters). The folder name should not contain the following symbols: "\" "/" ":" "*" "?" """ "<" ">" "|". |
Item Name | Description |
|---|---|
Restore log information | Select this when restoring the log information. |
Folder for viewing restoration files | Click Add and then specify the folder that saves the file used for restoration. Multiple files can be specified. (Specify the folder that contains the COMMONLOG1.csv and LOGKEWORDS.csv files backing up the log information.) The related buttons and check boxes are as follows:
An absolute path can contain a maximum of 189 single-byte characters (94 fullwidth characters). If an absolute path containing more than 189 halfwidth characters (94 fullwidth characters) is entered, only 189 halfwidth characters (94 fullwidth characters) are displayed. |
Item Name | Description |
|---|---|
Target folder for management Information backup | Specify the target folder that saves the backup management information. (To avoid errors during management information restoration, back up the most recent management information before restoration is carried out.) There are two methods:
The Viewing Folder window is displayed. Select the folder that saves the management information used for restoration and then click OK. An absolute path can contain a maximum of 189 single-byte characters (94 fullwidth characters). The folder name should not contain the following symbols: "\" "/" ":" "*" "?" """ "<" ">" "|". |
Item Name | Description |
|---|---|
Result log file | Specify the file for saving the execution results of the Restoration Tool. There are two methods for specifying such a file:
An absolute path can contain a maximum of 255 single-byte characters (127 fullwidth characters). The file name should not contain the following symbols: "\" "/" ":" "*" "?" """ "<" ">" "|". |
When the file exists | Select the processing operation to be performed when the result log file exists at the location specified by Result Log File.
|
Item Name | Description |
|---|---|
Work folder | Specify a folder for saving the working file. When restoring management information to this working folder, a working file that is 1.2 times the total size of the management information data files will be created. When restoring the log information, a working file that is 1.2 times the largest log table from the total of each log table under all of the folders will be created, therefore, ensure that there is sufficient space in the specified folder (for example, if the total size of all FILEACCESSLOG.csv files is 10 GB, then 12 GB will be required). The minimum available space required is 10 MB. After restoration is completed, the working file will be deleted.
An absolute path can contain a maximum of 189 single-byte characters (94 fullwidth characters). The folder name should not contain the following symbols: "\" "/" ":" "*" "?" """ "<" ">" "|". |
After completing all the settings, click Execute.
The confirmation window is displayed.
Click OK to start execution. The Restoration Status window will be displayed and the restoration process will start.
When the restoration process is completed successfully, the process completion window is displayed. Click OK in the window.
After confirming the execution status, click Close.
When managing iOS devices, execute swss_MDMDB_RESTORE.exe (restore iOS management database command) to restore iOS management databases. Execute this command on the Management Server.
Start the stopped "Level Control Service" and "Server Service". Select Start Service from the Service menu. The service startup confirmation window is displayed. Click OK in the window to start the services.
The operation result window is displayed. Click OK in the window.
Re-set the following settings in the Terminal Operation Settings window of the management console, which are recorded during backup.
Perform the following steps to display the Terminal Operation Settings window:
Start Management Console.
Select Terminal Operation Settings from the Operation Settings menu.
The Terminal Operation Settings window is displayed.
When managing Android or iOS devices, use SDSVService.bat (start/stop service of Smart Device Relay Server command) to start the service of the Smart Device Relay Server. Refer to "SDSVService.bat (Start/Stop Service of Smart Device Relay Server)" in the Systemwalker Desktop Keeper Reference Manual for details.
Restore the Database for Log Viewing
Point
Log information and administrator information obtained in older versions can also be browsed by restoring it to the Log Viewing Database.
When restoring log information backed up on a Master Management Server in a 3-level structure to the Log Viewing Database, the Master Management Server IP address that is displayed in the client (CT) operation log window becomes the Management Server IP address used when building the Log Viewing Database. Also, the downstream Management Server IP address will be displayed as "0.0.0.0".
When restoring log information backed up on a downstream Management Server in a 3-level structure or Management Server in a 2-level structure to the Log Viewing Database, the Management Server IP address that is displayed in the client (CT) operation log window becomes the Management Server IP address used when building the Log Viewing Database.
Log on the Windows OS as a user of the Administrators group or Domain Admins group. If there are other running applications, exit them.
Select All Programs > Systemwalker Desktop Keeper > Server > Restoration Tool of Database for Log Viewing from the Start/Apps menu on the computer installed with the Management Server or Master Management Server.
The Restoration Tool of database for viewing logs window is displayed.
Enter the user ID (user ID with backup and restore permission) and password registered using the Server Settings Tool, and then click OK.
You can also log in using the primary administrator user ID and password
The Restoration Tool of database for viewing logs window is displayed.
Except for certain items, the menu bar settings and input information of the Database Restoration Tool for Log Viewing are same as those of the Operation Database Restoration Tool. For details about the items that are the same for both tools, refer to the description about the Operation Database Restoration Tool. The items that can be set only by the Database Restoration Tool for Log Viewing are described here.
Item Name | Description |
|---|---|
Existing log information before restoration | If the database for log viewing contains log information, delete all the log information from the database before restoration. |
After completing all the settings, click Execute.
The confirmation window is displayed.
Click OK to start execution. The Restoration Status window will be displayed and the restoration process will start.
When the restoration process is completed successfully, the process completion window is displayed. Click OK in the window.
After confirming the execution status, click Close.
Exit the Restoration Tool
This describes how to exit the Restoration Tool.
To exit the Restoration Tool, select Exit from the File menu.
The exit confirmation window is displayed.
Select whether to save the conditions specified in the Restoration Tool window. Click Yes to exit with the conditions saved, click No to exit without saving the conditions, or click Cancel to cancel the exiting operation.
The menu settings (Settings of Debugging Trace) are saved when they are set.
Restore user assets
Refer to "3.1.1.2 User Assets" for details.
