LiteSpeed for SQL Server 8.9.5 - Security and Compliance Guide

Introduction LiteSpeed Security Features LiteSpeed for SQL Server and FISMA Compliance Customer Measures

Convert LiteSpeed Backups to SQL Server Backups

The extraction utility (extractor.exe) allows you to create MTF compliant SQL Server backup files from LiteSpeed backup files through the command-line. The devices created by the extractor utility can be restored on any SQL Server using the native RESTORE DATABASE or RESTORE LOG commands. The utility must be run on the server where the backup files are located.

NOTE: To convert TSM objects, see Recast LiteSpeed Backups.

This topic covers:

Syntax
Arguments
Examples
Returns

To use the utility, run the command line and change the directory until you are in the LiteSpeed installation directory (Usually, C:\Program Files\Quest Software\LiteSpeed\SQL Server).

Syntax

extractor.exe ( -? | ( [-F <sqllitespeed_backup_file>]
        [-E <base_file_name>]
        [-N <file_number>]
        [-K <encryption_key>]
        [-L (0|1|2)]
        [-c <tsm_client_node>]

        [-i <tsm_filespace>]
        [-k <tsm_owner_password>]
        [-j <tsm_config_file>]
        [--TSMPointInTime <date_time>]
        [-I] ) )

Arguments

NOTES:

Single-letter arguments are case-sensitive, and they can be preceded by a figure dash '-' or '/'.
Verbose multi-letter arguments are not case-sensitive, they must be preceded by double dashes '--'.

-Argument	--Argument	Description
-?	--ShowHelp	Displays the syntax summary of the LiteSpeed command-line utility.
-c	--TSMClientNode	Specifies the TSM server LiteSpeed connects to during backups and restores. Not required, if specified in the options file or if backing up with the Passwordaccess Generate option.
-E	--MTFFile	Specify the location and name of the Microsoft Tape Format (MSTF) base file. The extractor utility will create one backup device file for each thread used in a LiteSpeed backup. The extracted files containing the native SQL Server backup will have the following format: base_file_namex. Where: base_file_name is the specified Microsoft Tape Format base file. x is a number or letter that represents the sequence of the files. In case there are no additional files, the base file will not have an x appended to its name. NOTES: You can specify a network destination for this parameter. You only need to specify this parameter once. The extraction utility will create all the necessary files automatically. You cannot tell the extraction utility to extract a different number of native SQL Server files. However, you can specify different destinations for the extracted files by supplying a file name with the -E parameter for each of the native SQL Server files. To see how many files extractor.exe will create, run it without this parameter. See example 4 for more information. If a full path is not specified, the extracted files will be created in the current directory.
-F	--BackupFile	The name of the LiteSpeed backup device file to be extracted. This argument accepts network destinations. For TSM backups and TSM archives, this argument accepts the following formats: tsmbkp:<filespace>\<high>\<low> tsmarc:<filespace>\<high>\<low> You can supply multiple instances of this argument.
-I	--Overwrite	Re-initializes (overwrites and replaces) the target native backup files.
(none)	--trace	Writes a log file for the operation. Tracing functionality is configurable by the following parameters: This argument accepts the following format: --<this_argument>="<parameter_name>=<parameter_value>" -<this_argument>="<parameter_name>=<parameter_value>" See Configure Logging in LiteSpeed for information about LiteSpeed logging.
-j	--TSMConfigFile	Specifies the TSM configuration file.
-k	--TSMClientOwnerPwd	Specifies the TSM client owner user password. Not required, if specified in the options file or if backing up with the Passwordaccess Generate option.
-i	--TSMFile	Defines the TSM filespace, high level and low level. This argument accepts the following format: tsm_filespace\tsm_high_level\tsm_low_level where: tsm_filespace is the logical space on the TSM server that contains a group of files. It can be the drive label name or UNC name. tsm_high_level specifies the directory path in which the file belongs. tsm_low_level specifies actual name of the file. NOTE: You may only store one item the location specified by this argument. It is not possible to append an object to this location. You can use the -I command-line argument or @init to back up to a non-unique location.
(none)	--TSMPointInTime	Specifies the date for restore/to filter results. If it is not passed, LiteSpeed will choose the most recent archived backup. The format is yyyy-mm-dd hh:mm:ss. NOTE: If the backup was a striped backup and the point-in-times of the various striped files are different (rare but can be different a second or so), then the most recent of the times must be chosen.
-L	--LogLevel	Creates a log file. This argument accepts one of the following values: 0—Logging off. 1 or any odd value—Logging on. Log file is removed on success. 2 or any even value—Logging on. The default output directory is C:\Documents and Settings\All Users\Application Data\Quest Software\LiteSpeed\SQL Server\Logs (or C:\ProgramData\Quest Software\LiteSpeed\SQL Server\Logs) (or C:\ProgramData\Quest Software\LiteSpeed\SQL Server\Logs). To log to a different directory run this utility with the following argument: --trace logpath = "path". For more information, see Configure Logging in LiteSpeed. If you need to use the advanced tracing options, use the trace parameter instead.
-K	--Key	Type: Varchar Value used to generate the encryption key for the encryption algorithm. If you do not supply encryption key, then the program will not encrypt the backup. If you use the wrong encryption key, the restore will fail. Caution: When encrypting data, take care not to lose the encryption key; a backup cannot be restored or recovered without the original encryption key. Example of key: 'Mypassword'
-N	--BackupIndex	Specifies the particular backup to use when recasting, restoring, extracting or reading from files with multiple appended backups. A backup file can contain multiple backups. Each time you append a new backup, a sequential number is assigned to this backup within the backup file. You can run xp_restore_headeronly to query the files contained within the backup set given by backup_file_name.

Examples

Extract a LiteSpeed backup to a Network Share:

extractor.exe -F "C:\temp\Northwind.bak" -E \\my_server\my_share\Native.bak
Extract only the first backup in a backup set:

extractor.exe -F "C:\temp\Northwind.bak" -E "C:\temp\NorthwindNative.bak" -N 1
Extract a striped LiteSpeed backup:

extractor.exe -F "C:\temp\LS1.bak" -F "C:\temp\LS2.bak" -F "C:\temp\LS3.bak" -F "C:\temp\LS4.bak" -E "C:\temp\Native.bak"

NOTE: The number of extracted files does not have to match the number of files in a LiteSpeed backup. For more information, see Arguments. about the -E parameter.
Extract a LiteSpeed backup to different locations.
1. See how many destination files the extractor utility is going to create for the LiteSpeed backup:
  
  extractor.exe -F"c:\Backup\Northwind.bak"
2. Specify one filename for each destination file. The number of file names you specify with the -E parameter must match the number of files the extractor utility has returned for the LiteSpeed backup. The example below has 3 destination files:
  
  extractor.exe -F"c:\Backup\Northwind.bak" –E "c:\Data\NW1.bak" "e:\Data\NW2.bak" \\my_server\my_share\NW3.bak
Extract a TSM backup to native SQL Server backup:

extractor.exe -c"10.0.1.200" -k"password" -j"C:\Program Files\Tivoli\TSM\baclient\dsm.opt" -F tsmbkp:fsMH\nw\test -E "C:\temp\TestNative.bak"

Returns

0 (success) or 1 (failure)

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem