3.3.3 Restore Assets

This section describes the restoration process.

Restoration Process

Log on as the Log Analyzer user (the Windows user account set during installation of the Log Analyzer Server).
Select All Programs > Systemwalker Desktop Keeper > Log Analyzer > Operating Environment Maintenance Wizard > from the Start/Apps menu to re-construct the database.
Use the setting information backup and restoration command (LADBBKRS.bat) of the Log Analyzer to restore the setting information backup CSV to the database.
For details about the commands, refer to the "LADBBKRS.BAT (Backup/Restore Log Analyzer Settings Information)" in the Systemwalker Desktop Keeper Reference Manual.
Example:
```
LADBBKRS.bat -rs -d c:\backup
```
Copy the log information backup CSV from the external media to a shared folder (the folder specified by the -f option of the data transfer and deletion command adaptable to the Log Analyzer Server in step 5) without changing the folder structure.
Change the file name in the copied folder.
- File name before change: conv_end
- File name after change: trans_end
This file exists under each folder named after a date (for example, 20080421_20080421).
If there are a large number of such files, change the file names by running the following batch commands.
[Example of a batch file]
```
ECHO OFF
IF %1.==. GOTO NOPARAM
FOR /R %1 /D %%f IN (*) DO (
  IF EXIST %%f\conv_end (
    move %%f\conv_end %%f\trans_end
  )
)
GOTO END
:NOPARAM
ECHO Please specify a path to the folder.
:END
ECHO ON
```
For example, after copying the backup data from z:\DTKDATA to the share folder c:\DTKDATA, run the created batch commands.
Example:
```
conv.bat c:\DTKDATA
```
Use the transfer and deletion command (DTTOOLEX.EXE) adaptable to the Log Analyzer Server to re-transfer the log information backup CSV.
The re-transfer process may take some time.
For reference: The re-transfer of about 0.18 billion logs will take 24 hours.
For details about the commands, refer to the "DTTOOLEX.EXE DTTOOLEX.EXE (Data Transfer to/Delete from the Log Analyzer Server)" in the Systemwalker Desktop Keeper Reference Manual.
Example:
```
dttoolEx.exe -f c:\DTKDATA
```
Restore the setting information backup CSV to the database by using the restoration commands again.
Example:
```
LADBBKRS.bat -rs -d c:\backup
```
Start operation again (by using the data transmission command and data transfer command).

Note

Run the restoration commands for two times.
If step 7 is not performed to restore the setting information again, the data may be incorrectly restored. For example, the user ID may be deleted or the setting information may be outdated.

This section describes how to restore the backup data to the database by using the restoration commands provided by the Systemwalker Desktop Keeper Log Analyzer Server. The restoration commands are the same as the backup commands.

Note

Notes on using the restoration commands

[Level at which this command can be used]: This command can be used in V15.1.0 or later. These commands may fail if they are used in the environment constructed under other versions.

[Execution privileges for Windows Server(R) 2008 and Windows Server(R) 2012]: In Windows Server(R) 2008 and Windows Server(R) 2012, execution of the restoration commands requires administrator authority. Before running the restoration commands, log on to the Windows OS as a user of the Administrators group or Domain Admins group.

[Enable the command extension function of the command prompt]: Execution of the restoration commands requires that the command extension function of the command prompt be enabled.
The command extension function is enabled by default. Run "echo %CMDEXTVERSION%" in the command prompt window. If the output value is larger than or equal to 2, you can infer that the command extension function is enabled.

Target folder that saves the restoration commands:

[Installation folder of the Log Analyzer Server]\bin\SWDTLAENV
Example: C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\LogAnalyzer\Server\bin\SWDTLAENV

Command Name	Operation
LADBBKRS.BAT	Restore each table related to "setting information" described in "3.3.1 Summary and Backup Target Assets" as a CSV file.

Refer to "LADBBKRS.BAT (Backup/Restore Log Analyzer Settings)" in the Systemwalker Desktop Keeper Reference Manual for details on each command.

Start Restoration

Refer to "LADBBKRS.BAT (Backup/Restore Log Analyzer Settings)" in the Systemwalker Desktop Keeper Reference Manual for details on the restoration command.

Note

Do not use the Log Analyzer during restoration.

Do not use the Log Analyzer functions, such as the Web console, Report Output Tool, data transfer command, and user management command, before backup or restoration.

3.3.3 Restore Assets

3.3.3.1 Restoration Process

3.3.3.2 Using the Restoration Commands