:::: MENU ::::

Extract LiteSpeed backups to native format

Extracting

If you don’t want  or can’t use LiteSpeed to restore a backup you have to extract it to native SQL Server format. Quest has a commandline tool for this purpose, no gui here but it is simple to use and pretty straightforward.

Usually placed in C:\Program Files\Quest Software\LiteSpeed\SQL Server.

The program’s name is extractor.exe. If you can’t find it easily then search for this name.
The syntax is :
extractor.exe -F [path to LiteSpeed backupfile] -E [native extracted backupfile]

Example: You have a LiteSpeed compressed backup C:\temp\testDB.bak that you want to extract to C:\temp\testDB_native.bak

extractor.exe -F  C:\temp\testDB.bak -E C:\temp\testDB_native.bak
Here comes the part where almost everyone wonders what went wrong, instead of one backupfile we get multiple, that is because LiteSpeed used multiple threads when executing the backup, resulting in multiple files, compressed together. When extracting these to native we get a striped backup set, with the number of files in the stripe matching the number of threads used by LiteSpeed. So when checking our native extracted backups we can get for example:
C:\temp\testDB_native.bak0
C:\temp\testDB_native.bak1
C:\temp\testDB_native.bak2

Restore

Well how do we restore these then? The same way we always restore a striped backup, we restore them by specifying all files in the backup, not just one as it usually is.
In this case using SSMS we would specify all 3 files, see screenshot below:
restore_multiple

Or in TSQL, the exact same command:

RESTORE DATABASE [testDB]
FROM  DISK = N’C:\temp\testDB_native.bak2′,
DISK = N’C:\temp\testDB_native.bak1′,
DISK = N’C:\temp\testDB_native.bak0′
GO

2 Comments

  • Mark Roman |

    This would be very helpful if it included how to extract an encrypted lightspeed backup. I am assuming there is a way to do it.

  • Richard |

    Hi Mark!

    Yup, as far as I know there is a -K switch to extractor.exe, so you put the -K and then the encryption key like this:

    extractor.exe -F [path to LiteSpeed backupfile] -E [native extracted backupfile] -K [encryption_key]

    Assuming that you know the encryption key of course.

    //Richard

So, what do you think ?