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
Specify it when backing up settings information.
Specify it when restoring settings information.
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
Ended normally
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.
Note
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, do not use Log Analyzer function.
When executing this command in the environment of Windows Server 2008, Windows Server 2012, or Windows Server 2016, it is necessary to open the command prompt with "Run as Administrator".
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, enclose it with "(Double quotations).
Do not perform backup/restore between different versions.
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