Learn more about using Litespeed Extractor via Command Line. Our Litespeed Support team is here to help you with your questions and concerns.

Litespeed Extractor Command Line | An Introduction

In the world of SQL Server backups, efficiency and flexibility are key. This is where the Extraction Utility steps in. It offers a seamless solution to transform LiteSpeed backup files into MTF-compliant SQL Server backup files via the command line.

Today, we are going to take a look at the syntax, examples, and nuances of this powerful tool.

Extractor Utility Syntax

The extractor utility offers a versatile syntax that lets users tailor their extraction process to specific requirements. Let’s break down the key elements of the syntax:

extractor.exe ( -? | ( [-F <sqllitespeed_backup_file>]

• `-F <sqllitespeed_backup_file>`: Specifies the LiteSpeed backup file to be extracted.
• `-E <base_file_name>`: Defines the base filename for the extracted SQL Server backup files.
• `-N <file_number>`: Extracts a specific backup file from a set.
• `-K <encryption_key>`: Includes an encryption key for secure extraction.
• `-L (0|1|2)`: Sets the LiteSpeed compression level (0 for none, 1 for fast, 2 for best).
• `-c <tsm_client_node>`: Specifies the TSM client node for TSM backups.
• `-i <tsm_filespace>`: Identifies the TSM filespace for TSM backups.
• `-k <tsm_owner_password>`: Provides the TSM owner password for authentication.
• `-j <tsm_config_file>`: Specifies the TSM configuration file.
• `–TSMPointInTime <date_time>`: Enables extraction to a specific point in time for TSM backups.
• `-I`: Ignores recovery information during extraction.

How to use the Extractor Utility

Here are a few examples to help understand the extractor utility better:

1. To extract a LiteSpeed backup to a Network Share:

   extractor.exe -F "C:\temp\SalesData.bak" -E \\my_server\my_share\SalesNative.bak
2. To extract only the first backup in a set:

   extractor.exe -F "C:\temp\Inventory.bak" -E "C:\temp\InventoryNative.bak" -N 1
3. Extract a striped LiteSpeed backup:

   extractor.exe -F "C:\temp\LS_Backup1.bak" -F "C:\temp\LS_Backup2.bak" -F "C:\temp\LS_Backup3.bak" -F "C:\temp\LS_Backup4.bak" -E "C:\temp\StripedNative.bak"
4. To extract a TSM backup to a 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"

In short, the extraction utility offers a world of possibilities for optimizing our SQL Server backup processes.

[Need assistance with a different issue? Our team is available 24/7.]

Conclusion

In brief, our Support Experts demonstrated how to use Litespeed Extractor via Command Line.