Functional Specification
Restores the "management information" and "log information" that is backed up by using a backup tool and backup command, into the log browsing database in backup unit. It is possible to replace the "management information", and replace or add the log information through options.
However, the operation database cannot be restored.
Command Format
DTKTBLRESTOR.EXE DTKDB2 <User> <Password> { MASTER | OPELOG | OPELOGF } { <InDir> | <InFile> } <WorkDir> [REPLACE]
Option
It is a fixed value.
It indicates restoring in log viewing database.
Specify the user ID (The access authority is the user ID of "Backup/Restore") registered in the Server Settings Tool.
Specify the user ID of the existing operation database while restoring to the log viewing database.
It can be executed by using the user ID and password of the default administrator.
Specify the <User> password.
Specify the data type of the object to be restored.
Specify when management information is to be restored.
Specify when log information is to be restored from a folder.
Specify when log information is to be restored from multiple folders.
When "MASTER" is specified in the restoration object, specify the folder storing management information in maximum of 189 characters, with full path beginning from the drive letter.
When "OPELOG" is specified in the restoration object, specify the folder storing log information in maximum of 189 characters, with full path beginning from the drive letter.
If the path comprises of halfwidth spaces, enclose both the ends with double quotation.
[Example of <InDir>]
"C:\Documents and Settings\Administrator\My Documents\LG20120621"
When "OPELOGF" is specified in the restoration object, specify the folder described in the file of the restoration target in maximum of 255 characters, with full path beginning from drive letter.
Set the file as text file in the local disk.
Specify the folders saving log information of the restoration object in maximum of 198 characters, with one folder in one line, in the file with full path beginning from the drive letter.
Up to 2000 folders can be described.
Because a line is imported as a path, double quotations need not be put even if the path comprises of halfwidth spaces.
[Examples of files describing the restoration object folders]
C:\Documents and Settings\Administrator\My Documents\LG20120621 C:\Documents and Settings\Administrator\My Documents\LG20120622 C:\Documents and Settings\Administrator\My Documents\LG20120623 C:\Documents and Settings\Administrator\My Documents\LG20120624 C:\Documents and Settings\Administrator\My Documents\LG20120625 C:\Documents and Settings\Administrator\My Documents\LG20120626
Specify the working folder to replace the input file during restoration in maximum of 189 characters, with full path beginning from drive letter.
Only local hard disk can be specified in the working folder.
While restoring management information, a working file of size 1.2 times the total size of management information data file is created in the working folder.
While restoring log information, a working file is created with size 1.2 times the maximum size of log table from the total sizes of all the log tables of all sub folders, (For example, if the total size of all files of FILEACCESSLOG.csv is 10GB, then working file of size 12GB is required.) Therefore, specify a disk with enough free space in the working folder. Free space of minimum 10MB is necessary. A working file gets deleted after execution.
Specify when already stored log information is to be deleted before restoring log information in the log viewing database.
If deleted, add and restore the log information.
The operation of this option is similar to the operation when the option of "delete all the existing log information before restoring (fast delete)" of the log viewing database restoration tool, is specified. Refer to the "Using the Restoration Tool" of the Installation Guide.
When a path with blank characters is specified in the command option, put double quotations. Double quotations cannot be specified for other options which do not specify the path.
Return Value
Ended normally
Ended abnormally
Location for Saving Commands
< Installation folder of database related files >\BackupCommand\DTKTBLRESTOR.EXE
Authority Required for Execution/Execution Environment
Execute with a user that belongs to the Administrators group of the local computer or a user that belongs to the Domain Admins group of the domain.
Execute on the Management Server/Master Management Server.
Note
Command execution results are output through the command prompt. If there are any execution results left, specify the file to output execution results by redirecting when this command is being executed
When executing this command in Windows Server 2008, Windows Server 2012, or Windows Server 2016, it is necessary to open the command prompt with "Run as Administrator".
Describe <Infile> in SJIS code.
Path comprising of UNICODE cannot be specified. Specify the line feeding character 2 bytes of CR+LF.
Example of Use/Execution Results/Output Format
[When log information is to be restored in log viewing database]
[Examples of execution of management information restoration]
C:\Program Files\Fujitsu\Systemwalker Desktop Keeper\DB\BackupCommand>DTKTBLRESTOR.exe DTKDB2 User Password MASTER d:\temp\MS20130723 C:\temp 2015/06/02 14:37:30 Started restoration command 2015/06/02 14:37:30 2015/06/02 14:37:30 Database : DTKDB2 2015/06/02 14:37:30 Restoration target : MASTER 2015/06/02 14:37:30 Input folder : d:\temp\MS20150602 2015/06/02 14:37:30 Work folder : C:\temp 2015/06/02 14:37:32 * Deletion status of record in management information table 2015/06/02 14:37:32 2015/06/02 14:37:32 Delete management information - Start 2015/06/02 14:37:32 2015/06/02 14:37:32 - LEVELOBJECT 2015/06/02 14:37:32 Number of object items......27 2015/06/02 14:37:32 deletion completed 2015/06/02 14:37:32 2015/06/02 14:37:32 - LEVELCOMPOSITION 2015/06/02 14:37:32 Number of object items......26 2015/06/02 14:37:32 deletion completed 2015/06/02 14:37:32 2015/06/02 14:37:32 - PRINTPERMISSION 2015/06/02 14:37:32 Number of object items......0 2015/06/02 14:37:32 deletion completed 2015/06/02 14:37:32 2015/06/02 14:37:32 - LOGINGUARD 2015/06/02 14:37:32 Number of object items......0 2015/06/02 14:37:32 deletion completed 2015/06/02 14:37:32 2015/06/02 14:37:32 - STARTUPGUARD 2015/06/02 14:37:32 Number of object items......1 2015/06/02 14:37:32 deletion completed 2015/06/02 14:37:32 2015/06/02 14:37:32 - USERINFO 2015/06/02 14:37:32 Number of object items......7 2015/06/02 14:37:33 deletion completed 2015/06/02 14:37:33 2015/06/02 14:37:33 - NODEINFO 2015/06/02 14:37:33 Number of object items......1 2015/06/02 14:37:33 deletion completed 2015/06/02 14:37:33 2015/06/02 14:37:33 - PHYSICALNODELIST 2015/06/02 14:37:33 Number of object items......1 2015/06/02 14:37:33 deletion completed 2015/06/02 14:37:33 2015/06/02 14:37:33 - SETTINGS 2015/06/02 14:37:33 Number of object items......6 2015/06/02 14:37:33 deletion completed 2015/06/02 14:37:33 2015/06/02 14:37:33 - SETTINGSLOG 2015/06/02 14:37:33 Number of object items......778 2015/06/02 14:37:34 deletion completed 2015/06/02 14:37:34 2015/06/02 14:37:34 - FILEACC_ACQUIREPROCESS 2015/06/02 14:37:34 Number of object items......130 2015/06/02 14:37:34 deletion completed 2015/06/02 14:37:34 2015/06/02 14:37:34 - FILEACC_ACQUIREEXTENSION 2015/06/02 14:37:34 Number of object items......0 2015/06/02 14:37:34 deletion completed 2015/06/02 14:37:34 2015/06/02 14:37:34 - MAILATTACHSET 2015/06/02 14:37:34 Number of object items......0 2015/06/02 14:37:34 deletion completed 2015/06/02 14:37:34 2015/06/02 14:37:34 - WINDOWTITLELOGFILTER 2015/06/02 14:37:34 Number of object items......0 2015/06/02 14:37:34 deletion completed 2015/06/02 14:37:34 2015/06/02 14:37:34 - WINDOWCAPTUREFILTER 2015/06/02 14:37:34 Number of object items......0 2015/06/02 14:37:34 deletion completed 2015/06/02 14:37:34 2015/06/02 14:37:34 - USERPOLICYINFO 2015/06/02 14:37:34 Number of object items......2 2015/06/02 14:37:34 deletion completed 2015/06/02 14:37:34 2015/06/02 14:37:34 - LOGONUSER_PRINTPERMISSION 2015/06/02 14:37:34 Number of object items......0 2015/06/02 14:37:34 deletion completed 2015/06/02 14:37:34 2015/06/02 14:37:34 - LOGONUSER_STARTUPGUARD 2015/06/02 14:37:34 Number of object items......0 2015/06/02 14:37:35 deletion completed 2015/06/02 14:37:35 2015/06/02 14:37:35 - LOGONUSER_SETTINGSLOG 2015/06/02 14:37:35 Number of object items......0 2015/06/02 14:37:35 deletion completed 2015/06/02 14:37:35 2015/06/02 14:37:35 - USERMAILATTACHSET 2015/06/02 14:37:35 Number of object items......0 2015/06/02 14:37:35 deletion completed 2015/06/02 14:37:35 2015/06/02 14:37:35 - LOGONUSER_WINDOWTITLELOGFILTER 2015/06/02 14:37:35 Number of object items......0 2015/06/02 14:37:35 deletion completed 2015/06/02 14:37:35 2015/06/02 14:37:35 - LOGONUSER_WINDOWCAPTUREFILTER 2015/06/02 14:37:35 Number of object items......0 2015/06/02 14:37:35 deletion completed 2015/06/02 14:37:35 2015/06/02 14:37:35 - DOMAINSETTINGS 2015/06/02 14:37:35 Number of object items......1 2015/06/02 14:37:35 deletion completed 2015/06/02 14:37:35 2015/06/02 14:37:35 - OBJECT_CONTROL 2015/06/02 14:37:35 Number of object items......0 2015/06/02 14:37:35 deletion completed 2015/06/02 14:37:35 2015/06/02 14:37:35 - LOGONUSER_LEVELCOMPOSITION 2015/06/02 14:37:35 Number of object items......2 2015/06/02 14:37:35 deletion completed 2015/06/02 14:37:35 2015/06/02 14:37:35 - LOGONUSER_CONTROL 2015/06/02 14:37:35 Number of object items......0 2015/06/02 14:37:35 deletion completed 2015/06/02 14:37:35 2015/06/02 14:37:35 - USBMASTER 2015/06/02 14:37:35 Number of object items......3 2015/06/02 14:37:36 deletion completed 2015/06/02 14:37:36 2015/06/02 14:37:36 - POLICYTABLE 2015/06/02 14:37:36 Number of object items......3 2015/06/02 14:37:36 deletion completed 2015/06/02 14:37:36 2015/06/02 14:37:36 - DTK_AUDIT_SETTING 2015/06/02 14:37:36 Number of object items......83 2015/06/02 14:37:36 deletion completed 2015/06/02 14:37:36 2015/06/02 14:37:36 - DTK_TOTAL_ALERTLOG 2015/06/02 14:37:36 Number of object items......7 2015/06/02 14:37:36 deletion completed 2015/06/02 14:37:36 2015/06/02 14:37:36 - DTK_ALERT_LIST 2015/06/02 14:37:36 Number of object items......7 2015/06/02 14:37:37 deletion completed 2015/06/02 14:37:37 2015/06/02 14:37:37 - DTK_ALERTPC_LIST 2015/06/02 14:37:37 Number of object items......3 2015/06/02 14:37:37 deletion completed 2015/06/02 14:37:37 2015/06/02 14:37:37 - DTK_PRINTER_OBJECTMASTER 2015/06/02 14:37:37 Number of object items......0 2015/06/02 14:37:37 deletion completed 2015/06/02 14:37:37 2015/06/02 14:37:37 - DTK_PRINTER_PRINTUSERMASTER 2015/06/02 14:37:37 Number of object items......0 2015/06/02 14:37:37 deletion completed 2015/06/02 14:37:37 2015/06/02 14:37:37 - DTK_PRINTER_PAPERNUM_BASIC 2015/06/02 14:37:37 Number of object items......0 2015/06/02 14:37:37 deletion completed 2015/06/02 14:37:37 2015/06/02 14:37:37 Delete management information - End 2015/06/02 14:37:37 2015/06/02 14:37:37 Restore management information collectively - Start 2015/06/02 14:37:37 2015/06/02 14:37:38 - LEVELOBJECT 2015/06/02 14:37:38 Input file name : C:\temp\LEVELOBJECT.tmp 2015/06/02 14:37:38 Number of files......9 2015/06/02 14:37:38 Number of input items ......9 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - LEVELCOMPOSITION 2015/06/02 14:37:38 Input file name : C:\temp\LEVELCOMPOSITION.tmp 2015/06/02 14:37:38 Number of files......8 2015/06/02 14:37:38 Number of input items ......8 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - PRINTPERMISSION 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\PRINTPERMISSION.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - LOGINGUARD 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\LOGINGUARD.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - STARTUPGUARD 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\STARTUPGUARD.csv 2015/06/02 14:37:38 Number of files......1 2015/06/02 14:37:38 Number of input items ......1 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - USERINFO 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\USERINFO.csv 2015/06/02 14:37:38 Number of files......8 2015/06/02 14:37:38 Number of input items ......8 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - NODEINFO 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\NODEINFO.csv 2015/06/02 14:37:38 Number of files......1 2015/06/02 14:37:38 Number of input items ......1 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - PHYSICALNODELIST 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\PHYSICALNODELIST.csv 2015/06/02 14:37:38 Number of files......2 2015/06/02 14:37:38 Number of input items ......2 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - SETTINGS 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\SETTINGS.csv 2015/06/02 14:37:38 Number of files......6 2015/06/02 14:37:38 Number of input items ......6 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - SETTINGSLOG 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\SETTINGSLOG.csv 2015/06/02 14:37:38 Number of files......485 2015/06/02 14:37:38 Number of input items ......485 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - FILEACC_ACQUIREPROCESS 2015/06/02 14:37:38 Input file name : C:\temp\FILEACC_ACQUIREPROCESS.tmp 2015/06/02 14:37:38 Number of files......45 2015/06/02 14:37:38 Number of input items ......45 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - FILEACC_ACQUIREEXTENSION 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\FILEACC_ACQUIREEXTENSION.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - MAILATTACHSET 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\MAILATTACHSET.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - WINDOWTITLELOGFILTER 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\WINDOWTITLELOGFILTER.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - WINDOWCAPTUREFILTER 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\WINDOWCAPTUREFILTER.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - USERPOLICYINFO 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\USERPOLICYINFO.csv 2015/06/02 14:37:38 Number of files......4 2015/06/02 14:37:38 Number of input items ......4 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - LOGONUSER_PRINTPERMISSION 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\LOGONUSER_PRINTPERMISSION.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - LOGONUSER_STARTUPGUARD 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\LOGONUSER_STARTUPGUARD.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - LOGONUSER_SETTINGSLOG 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\LOGONUSER_SETTINGSLOG.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - USERMAILATTACHSET 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\USERMAILATTACHSET.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - LOGONUSER_WINDOWTITLELOGFILTER 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\LOGONUSER_WINDOWTITLELOGFILTER.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - LOGONUSER_WINDOWCAPTUREFILTER 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\LOGONUSER_WINDOWCAPTUREFILTER.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - DOMAINSETTINGS 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\DOMAINSETTINGS.csv 2015/06/02 14:37:38 Number of files......2 2015/06/02 14:37:38 Number of input items ......2 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - OBJECT_CONTROL 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\OBJECT_CONTROL.csv 2015/06/02 14:37:38 Number of files......1 2015/06/02 14:37:38 Number of input items ......1 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - LOGONUSER_LEVELCOMPOSITION 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\LOGONUSER_LEVELCOMPOSITION.csv 2015/06/02 14:37:38 Number of files......4 2015/06/02 14:37:38 Number of input items ......4 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - LOGONUSER_CONTROL 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\LOGONUSER_CONTROL.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - USBMASTER 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\USBMASTER.csv 2015/06/02 14:37:38 Number of files......3 2015/06/02 14:37:38 Number of input items ......3 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - POLICYTABLE 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\POLICYTABLE.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - DTK_AUDIT_SETTING 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\DTK_AUDIT_SETTING.csv 2015/06/02 14:37:38 Number of files......83 2015/06/02 14:37:38 Number of input items ......83 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - DTK_TOTAL_ALERTLOG 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\DTK_TOTAL_ALERTLOG.csv 2015/06/02 14:37:38 Number of files......7 2015/06/02 14:37:38 Number of input items ......7 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - DTK_ALERT_LIST 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\DTK_ALERT_LIST.csv 2015/06/02 14:37:38 Number of files......7 2015/06/02 14:37:38 Number of input items ......7 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - DTK_ALERTPC_LIST 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\DTK_ALERTPC_LIST.csv 2015/06/02 14:37:38 Number of files......3 2015/06/02 14:37:38 Number of input items ......3 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - DTK_PRINTER_OBJECTMASTER 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\DTK_PRINTER_OBJECTMASTER.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - DTK_PRINTER_PRINTUSERMASTER 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\DTK_PRINTER_PRINTUSERMASTER.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 - DTK_PRINTER_PAPERNUM_BASIC 2015/06/02 14:37:38 Input file name : d:\temp\MS20150602\DTK_PRINTER_PAPERNUM_BASIC.csv 2015/06/02 14:37:38 Number of files......0 2015/06/02 14:37:38 Number of input items ......0 2015/06/02 14:37:38 Number of error items ......0 (Normal) 2015/06/02 14:37:38 2015/06/02 14:37:38 Restore management information collectively - End 2015/06/02 14:37:38
[Examples of execution log information restoration (in the case of OPELOG)]
C:\Program Files (x86)\Fujitsu\Systemwalker Desktop Keeper\DB\BackupCommand>DTKTBLRESTOR.exe DTKDB2 User Password OPELOG d:\temp\BK20120601 C:\temp REPLACE 2015/06/02 16:21:41 Started restoration command 2015/06/02 16:21:41 2015/06/02 16:21:41 Database : DTKDB2 2015/06/02 16:21:41 Restoration target : OPELOG 2015/06/02 16:21:41 Input folder : d:\temp\BK20150601 2015/06/02 16:21:41 Work folder : C:\temp 2015/06/02 16:21:41 All deletions : REPLACE 2015/06/02 16:21:41 Restore log information - Start 2015/06/02 16:21:41 2015/06/02 16:21:41 * Deletion status of record in log table 2015/06/02 16:21:41 2015/06/02 16:21:41 Delete logs - Start 2015/06/02 16:21:41 2015/06/02 16:21:41 - COMMONLOG1 2015/06/02 16:21:41 Number of object items......32 2015/06/02 16:21:41 deletion completed 2015/06/02 16:21:41 2015/06/02 16:21:41 - COMMONLOG2 2015/06/02 16:21:41 Number of object items......150 2015/06/02 16:21:41 deletion completed 2015/06/02 16:21:41 2015/06/02 16:21:41 - COMMONLOG3 2015/06/02 16:21:41 Number of object items......25 2015/06/02 16:21:42 deletion completed 2015/06/02 16:21:42 2015/06/02 16:21:42 - LOGKEYWORDS 2015/06/02 16:21:42 Number of object items......207 2015/06/02 16:21:42 deletion completed 2015/06/02 16:21:42 2015/06/02 16:21:42 - STARTUPGUARDLOG 2015/06/02 16:21:42 Number of object items......0 2015/06/02 16:21:42 deletion completed 2015/06/02 16:21:42 2015/06/02 16:21:42 - LOGINGUARDLOG 2015/06/02 16:21:42 Number of object items......0 2015/06/02 16:21:42 deletion completed 2015/06/02 16:21:42 2015/06/02 16:21:42 - PRINTLOG 2015/06/02 16:21:42 Number of object items......0 2015/06/02 16:21:42 deletion completed 2015/06/02 16:21:42 2015/06/02 16:21:42 - FILEBRINGOULOG 2015/06/02 16:21:42 Number of object items......0 2015/06/02 16:21:43 deletion completed 2015/06/02 16:21:43 2015/06/02 16:21:43 - FILEACCESSLOG 2015/06/02 16:21:43 Number of object items......661 2015/06/02 16:21:43 deletion completed 2015/06/02 16:21:43 2015/06/02 16:21:43 - SESSIONMANAGE 2015/06/02 16:21:43 Number of object items......10 2015/06/02 16:21:43 deletion completed 2015/06/02 16:21:43 2015/06/02 16:21:43 - USERLIST 2015/06/02 16:21:43 Number of object items......5 2015/06/02 16:21:43 deletion completed 2015/06/02 16:21:43 2015/06/02 16:21:43 - Command prompt detail file 2015/06/02 16:21:43 deletion completed 2015/06/02 16:21:43 2015/06/02 16:21:43 Delete logs - End 2015/06/02 16:21:43 2015/06/02 16:21:44 - COMMONLOG1 2015/06/02 16:21:44 Input file name : C:\temp\COMMONLOG1.tmp 2015/06/02 16:21:44 Number of files......32 2015/06/02 16:21:44 Number of input items ......32 2015/06/02 16:21:44 Number of error items ......0 (Normal) 2015/06/02 16:21:44 Number of tables......32 2015/06/02 16:21:44 2015/06/02 16:21:44 - COMMONLOG2 2015/06/02 16:21:44 Input file name : C:\temp\COMMONLOG2.tmp 2015/06/02 16:21:44 Number of files......150 2015/06/02 16:21:44 Number of input items ......150 2015/06/02 16:21:44 Number of error items ......0 (Normal) 2015/06/02 16:21:44 Number of tables......150 2015/06/02 16:21:44 2015/06/02 16:21:44 - COMMONLOG3 2015/06/02 16:21:44 Input file name : C:\temp\COMMONLOG3.tmp 2015/06/02 16:21:44 Number of files......25 2015/06/02 16:21:44 Number of input items ......25 2015/06/02 16:21:44 Number of error items ......0 (Normal) 2015/06/02 16:21:44 Number of tables......25 2015/06/02 16:21:44 2015/06/02 16:21:44 - LOGKEYWORDS 2015/06/02 16:21:44 Input file name : C:\temp\LOGKEYWORDS.tmp 2015/06/02 16:21:44 Number of files......207 2015/06/02 16:21:44 Number of input items ......207 2015/06/02 16:21:44 Number of error items ......0 (Normal) 2015/06/02 16:21:44 Number of tables......207 2015/06/02 16:21:44 2015/06/02 16:21:44 - STARTUPGUARDLOG 2015/06/02 16:21:44 Input file name : C:\temp\STARTUPGUARDLOG.tmp 2015/06/02 16:21:44 Number of files......0 2015/06/02 16:21:44 Number of input items ......0 2015/06/02 16:21:44 Number of error items ......0 (Normal) 2015/06/02 16:21:44 Number of tables......0 2015/06/02 16:21:44 2015/06/02 16:21:44 - LOGINGUARDLOG 2015/06/02 16:21:44 Input file name : C:\temp\LOGINGUARDLOG.tmp 2015/06/02 16:21:44 Number of files......0 2015/06/02 16:21:44 Number of input items ......0 2015/06/02 16:21:44 Number of error items ......0 (Normal) 2015/06/02 16:21:44 Number of tables......0 2015/06/02 16:21:44 2015/06/02 16:21:44 - PRINTLOG 2015/06/02 16:21:44 Input file name : C:\temp\PRINTLOG.tmp 2015/06/02 16:21:44 Number of files......0 2015/06/02 16:21:44 Number of input items ......0 2015/06/02 16:21:44 Number of error items ......0 (Normal) 2015/06/02 16:21:44 Number of tables......0 2015/06/02 16:21:44 2015/06/02 16:21:44 - FILEBRINGOUTLOG 2015/06/02 16:21:44 Input file name : C:\temp\FILEBRINGOULOG.tmp 2015/06/02 16:21:44 Number of files......0 2015/06/02 16:21:44 Number of input items ......0 2015/06/02 16:21:44 Number of error items ......0 (Normal) 2015/06/02 16:21:44 Number of tables......0 2015/06/02 16:21:44 2015/06/02 16:21:44 - FILEACCESSLOG 2015/06/02 16:21:44 Input file name : C:\temp\FILEACCESSLOG.tmp 2015/06/02 16:21:44 Number of files......661 2015/06/02 16:21:44 Number of input items ......661 2015/06/02 16:21:44 Number of error items ......0 (Normal) 2015/06/02 16:21:44 Number of tables......661 2015/06/02 16:21:44 2015/06/02 16:21:44 - Started recreating the index 2015/06/02 16:21:46 Finished recreating the index 2015/06/02 16:21:46 2015/06/02 16:21:46 - SESSIONMANAGE 2015/06/02 16:21:46 Input file name : C:\temp\SESSIONMANAGE.tmp 2015/06/02 16:21:46 Number of files......10 2015/06/02 16:21:46 Number of error items ......0 (Normal) 2015/06/02 16:21:46 Number of tables......10 2015/06/02 16:21:46 2015/06/02 16:21:46 - Command prompt detail file 2015/06/02 16:21:46 Number of files......0 2015/06/02 16:21:46 2015/06/02 16:21:46 Restore log information - End 2015/06/02 16:21:46
[Examples of execution of log information restoration (in the case of OPELOGF)]
C:\Program Files (x86)\Fujitsu\Systemwalker Desktop Keeper\DB\BackupCommand>DTKTBLRESTOR.exe DTKDB2 User Password OPELOGF d:\temp\IMPORTLIST.txt c:\temp 2015/06/02 16:22:12 Started restoration command 2015/06/02 16:22:12 2015/06/02 16:22:12 Database : DTKDB2 2015/06/02 16:22:12 Restoration target : OPELOGF 2015/06/02 16:22:12 Input folder : d:\temp\IMPORTLIST.txt 2015/06/02 16:22:12 Work folder : C:\temp 2015/06/02 16:22:12 Restore log information - Start 2015/06/02 16:22:12 2015/06/02 16:22:13 - COMMONLOG1 2015/06/02 16:22:13 Input file name : C:\temp\COMMONLOG1.tmp 2015/06/02 16:22:13 Number of files......2,838 2015/06/02 16:22:13 Number of input items ......2,838 2015/06/02 16:22:13 Number of error items ......0 (Normal) 2015/06/02 16:22:13 Number of tables......2,870 2015/06/02 16:22:13 2015/06/02 16:22:13 - COMMONLOG2 2015/06/02 16:22:13 Input file name : C:\temp\COMMONLOG2.tmp 2015/06/02 16:22:13 Number of files......11,441 2015/06/02 16:22:13 Number of input items ......11,441 2015/06/02 16:22:13 Number of error items ......0 (Normal) 2015/06/02 16:22:13 Number of tables......11,591 2015/06/02 16:22:13 2015/06/02 16:22:13 - COMMONLOG3 2015/06/02 16:22:13 Input file name : C:\temp\COMMONLOG3.tmp 2015/06/02 16:22:13 Number of files......1,189 2015/06/02 16:22:13 Number of input items ......1,189 2015/06/02 16:22:13 Number of error items ......0 (Normal) 2015/06/02 16:22:13 Number of tables......1,214 2015/06/02 16:22:13 2015/06/02 16:22:14 - LOGKEYWORDS 2015/06/02 16:22:14 Input file name : C:\temp\LOGKEYWORDS.tmp 2015/06/02 16:22:15 Number of files......15,502 2015/06/02 16:22:15 Number of input items ......15,502 2015/06/02 16:22:15 Number of error items ......0 (Normal) 2015/06/02 16:22:15 Number of tables......15,709 2015/06/02 16:22:15 2015/06/02 16:22:15 - STARTUPGUARDLOG 2015/06/02 16:22:15 Input file name : C:\temp\STARTUPGUARDLOG.tmp 2015/06/02 16:22:15 Number of files......5 2015/06/02 16:22:15 Number of input items ......5 2015/06/02 16:22:15 Number of error items ......0 (Normal) 2015/06/02 16:22:15 Number of tables......5 2015/06/02 16:22:15 2015/06/02 16:22:15 - LOGINGUARDLOG 2015/06/02 16:22:15 Input file name : C:\temp\LOGINGUARDLOG.tmp 2015/06/02 16:22:15 Number of files......0 2015/06/02 16:22:15 Number of input items ......0 2015/06/02 16:22:15 Number of error items ......0 (Normal) 2015/06/02 16:22:15 Number of tables......0 2015/06/02 16:22:15 2015/06/02 16:22:15 - PRINTLOG 2015/06/02 16:22:15 Input file name : C:\temp\PRINTLOG.tmp 2015/06/02 16:22:15 Number of files......2 2015/06/02 16:22:15 Number of input items ......2 2015/06/02 16:22:15 Number of error items ......0 (Normal) 2015/06/02 16:22:15 Number of tables......2 2015/06/02 16:22:15 2015/06/02 16:22:15 - FILEBRINGOUTLOG 2015/06/02 16:22:15 Input file name : C:\temp\FILEBRINGOULOG.tmp 2015/06/02 16:22:15 Number of files......27 2015/06/02 16:22:15 Number of input items ......27 2015/06/02 16:22:15 Number of error items ......0 (Normal) 2015/06/02 16:22:15 Number of tables......27 2015/06/02 16:22:15 2015/06/02 16:22:17 - FILEACCESSLOG 2015/06/02 16:22:17 Input file name : C:\temp\FILEACCESSLOG.tmp 2015/06/02 16:22:24 Number of files......46,797 2015/06/02 16:22:24 Number of input items ......46,797 2015/06/02 16:22:24 Number of error items ......0 (Normal) 2015/06/02 16:22:24 Number of tables......47,458 2015/06/02 16:22:24 2015/06/02 16:22:24 - Started recreating the index 2015/06/02 16:22:29 Finished recreating the index 2015/06/02 16:22:29 2015/06/02 16:22:29 - SESSIONMANAGE 2015/06/02 16:22:29 Input file name : C:\temp\SESSIONMANAGE.tmp 2015/06/02 16:22:29 Number of files......76 2015/06/02 16:22:29 Number of error items ......0 (Normal) 2015/06/02 16:22:29 Number of tables......44 2015/06/02 16:22:29 2015/06/02 16:22:29 - Command prompt detail file 2015/06/02 16:22:29 Number of files......0 2015/06/02 16:22:29 2015/06/02 16:22:29 Restore log information - End 2015/06/02 16:22:29