1.21 LADBBKRS.BAT (Backup/Restore Log Analyzer Settings Information)

Functional Specification

Backup all tables recorded as setting information managed in database of the Log Analyzer Server of Systemwalker Desktop Keeper as a CSV file for each table.
In addition, the CSV data that has been backed up can be restored to database. However, backup and restoration of aggregation result information and log information will not be performed.

Command Format

LADBBKRS.BAT {-bs | -rs} -d <OutDir>

Option

-bs :: Specify it when backing up settings information.

-rs :: Specify it when restoring settings information.

-d <OutDir>:: Specify the directory for saving backup information or restoration information with full path.
Only the local folder can be specified. It cannot run normally in network folder.

Return Value

0 :: Ended normally

Other :: Ended abnormally

Location for Saving Commands

The following folder of Systemwalker Desktop Keeper the Log Analyzer Server

Installation folder of the Log Analyzer Server\bin\SWDTLAENV

Authority Required for Execution/Execution Environment

It can be executed by Log Analyzer user.
It can be executed on the Log Analyzer Server.

Notes

When the file with same name exists in the folder of output target, it will be overwritten. Confirmation message will not be displayed.
At backup/restore, please do not use Log Analyzer function.
When executing this command in the environment of Windows Server® 2008, it is necessary to open the command prompt with “Run as Administrator”.
Please execute this command after moving the current folder to the location for saving commands.
If the execution path of this command or the path specified with -d contains space, please enclose it with “(Double quotations).

Example of Use

At backup

LADBBKRS.BAT -bs -d c:\backup

At restoration

LADBBKRS.BAT -rs -d c:\backup

Execution Results/Output Format

At backup

Tue 05/19/2009  15:47:00.00 Settings Information Backup - Start
Tue 05/19/2009  15:47:01.00    database : SWDTLA
Tue 05/19/2009  15:47:02.00    directory : c:\backup
Tue 05/19/2009  15:47:03.00   - SETTING_INF
Tue 05/19/2009  15:47:04.00      output file name  :  c:\backup\SETTING_INF.csv 

    ~~ (Omitted) ~~

Tue 05/19/2009  15:50:00.00   - PRINTUSER_PARERNUM_BASIC
Tue 05/19/2009  15:50:01.00      output file name  :  c:\backup\USERSECTIONMASTER.csv
Tue 05/19/2009  15:50:02.00 Settings Information Backup - End

At restoration

Tue 05/19/2009  15:47:00.00 Settings Information Restore - Start
Tue 05/19/2009  15:47:01.00    database : SWDTLA
Tue 05/19/2009  15:47:02.00    directory : c:\backup
Tue 05/19/2009  15:47:03.00   - SETTING_INF
Tue 05/19/2009  15:47:04.00      input file name  :  c:\backup\SETTING_INF.csv 

    ~~ (Omitted) ~~

Tue 05/19/2009  15:50:00.00   - PRINTUSER_PARERNUM_BASIC
Tue 05/19/2009  15:50:01.00      input file name  :  c:\backup\USERSECTIONMASTER.csv
Tue 05/19/2009  15:50:02.00 Settings Information Restore - End