Are there any tools to convert backup file format from SQL Litespeed format to a SQL server generic backup format for the purpose of restoring the database on a SQL Server that doesn't have Litespeed installed.
LiteSpeed 2005 Extraction Utility
The extraction utility (extractor.exe) converts Litespeed backup file to Microsoft SQL Server native backup file. This utility is run on the server where the LiteSpeed 2005 backup devices are located.
The devices created by the extractor utility can be restored on any SQL Server using the native RESTORE DATABASE or RESTORE LOG commands.
To run the utility:
1. Open command prompt by going to Start | Run | cmd.exe
2. Change the directory to the location of extractor.exe. On a default installation this is: %PROGRAM_FILES%\IMCEDA\LiteSpeed\SQL Server
NOTE : If the LiteSpeed 2005 installation directory is defined under environment PATH the above step is not necessary
3. Run extractor.exe with the appropriate arguments - see below for the command syntax.
Extract the LiteSpeed 2005 backup ‘Northwind.bak’ to native SQL Server backup ‘NorthwindNative.bak’:
extractor.exe -Fc:\temp\Northwind.bak -Ec:\temp\NorthwindNative.bak -N1
This generates native SQL Server backup files. You can restore from them using native SQL Server RESTORE commands.
extractor.exe -R Extract
[-L 0|1|2 ]
NOTE: Parameters are case sensitive and can be preceded with "-" or "/"
The LiteSpeed backup process may have been run with multiple threads, this results in a series of files when extracted. These files are restored with the native commands as a striped backup. Example (LiteSpeed backed up using 3 threads):
RESTORE DATABASE Northwind
FROM DISK = 'd:\backup\NorthwindNative.bak0',
To restore a LiteSpeed backup file to a server without the LiteSpeed application, copy the LiteSpeed executable (SQLLiteSpeed.exe) along with the backup file to the server without LiteSpeed. This will allow a command line restore.
Creating a Double Click restore file is also an option.
The path for extractor.exe for versions 5.x is as follows:
...\Program Files\Quest Software\LiteSpeed\SQL Server
If you are extracting the master database, please remeber that the SQL Server versions on the source and destination must be on the same version. Otherwise the RESTORE on the destination may fail.