Error: "Not a Valid Microsoft Tape Backup Set" during restore.
How to create Microsoft Tape Format Compliant SQL Server Backup from LiteSpeed 2005 backup file using the extractor utility.
Native restore commands are being run on a server for a file created by LiteSpeed.
The extraction utility (extractor.exe) allows the creation of Microsoft Tape Format Compliant SQL Server Backup Devices from LiteSpeed 2005 compressed and encrypted backup devices from the Windows NT command line. This utility is run on the server that the LiteSpeed 2005 backup devices are located on. The devices created by the extractor utility can be restored on any SQL Server using the native RESTORE DATABASE or RESTORE LOG commands.
Obtain the Extractor.exe from any LiteSpeed server from "\Program Files\Imceda\LiteSpeed\SQL Server\Extractor.exe". This utility is used to create Microsoft Tape Format Compliant SQL Server Backup from LiteSpeed 2005 compressed and encrypted backup files.
This utility may be ran on any SQL Server from the command line using the native SQL restore database or restore log commands.
NOTE: Parameters are case sensitive and can be preceded with "-" or "/" Returns: 0 (success) or 1 (failure)
LiteSpeed 2005 extractor utility parameters: Argument Description -? Displays the syntax summary of LiteSpeed 2005 extractor utility switches -E base_file_name Specify the location and name of the Microsoft Tape Format (MSTF) base file This is the base file created by the extractor.exe, containing the native SQL Server backup. The extractor utility will create one backup device file for each thread used in a LiteSpeed 2005 backup. If a LiteSpeed 2005 backup was performed using multiple backup files (eg a "striped" backup), one MSTF device will be created for each backup file specified in the LiteSpeed 2005 backup. If a full path is not specified, the extracted files will be created in the current directory. Any additional files created will be named using the following naming convention: MTF.BAKx Where: 'MTF.BAK' is the specified Microsoft Tape Format base file x is a number or letter that represents the sequence of the files. x can take any value from [0..Y] -F The name of the LiteSpeed 2005 backup device file to be extracted. Multiple instances of this parameter can be supplied for multiple backup devices (e.g. striped backups). -I Used to re-initialize the extractor files 0 - Do not reinitialize the extractor files (default value) 1 - Reinitialize backup service -L Logging options 0.1.2 -K encryption_key String used to encrypt database backups and used for restore authorization. Default is No Encryption. -N file_number Number of the file to extract from backup
NOTE: Backup file may be encrypted and/or striped. Also see LiteSpeed Help File for additional detail.
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', disk='d:\backup\NorthwindNative.bak1', disk='d:\backup\NorthwindNative.bak2' WITH RECOVERY