How to extract a LiteSpeed backup file and stripe the results to more than one location, across several drives if the native file is too large for the space available.
WORKAROUND:
First, to determine how many files to create then just run it without *any* destination filenames and it will tell you the number of threads used to backup
extractor.exe -Fc:\Backup\Northwind.bak –N1
NOTE: If you give it multiple destination filenames- then you must give it the correct number (which is why this step is required).
Second, the extractor will create one native backup file for each thread/VDI device used in creating a LiteSpeed backup.
So if the backup was created on a quad-core system, then it probably used 3 threads by default.
That means your extractor command below will result in the following native backup files:
D:\Data\Northwind.bak0
D:\Data\Northwind.bak1
D:\Data\Northwind.bak2
Note that the extractor add the numeric indices for the user, but the user can pass in all 3 native backup names.
So run something like:
extractor.exe -Fc:\Backup\Northwind.bak –N1 –E g:\Data\NW1.bak h:\Data\NW2.bak i:\Data\NW3.bak
and name/put the resulting files anywhere with write permissions.
Third, restore the filkes using the native command RESTORE DATABASE.
Example:
RESTORE DATABASE Northwind
FROM DISK='g:\Data\NW1.bak',
disk=' h:\Data\NW2.bak',
disk='i:\Data\NW3.bak'
WITH MOVE 'database_name_Data' TO
'C:\program files\Microsoft SQL Server\MSSQL\Data\database_name_copy.mdf',
MOVE 'database_name_Log' TO
'C:\program files\Microsoft SQL Server\MSSQL\Data\database_name_copy.ldf',
WITH RECOVERY
