Server: Msg 49999, Level 19, State 1, Line 1
Not a valid LiteSpeed 2005 format file (Type is: 1).
You must select a valid LiteSpeed 2005 file to append backups or use the
@init option to delete the file.
Backup server is running a different, more recent version of LiteSpeed than the restore server.
1. Verify the backup file for type and possible corruption. From Query Analyzer:
XP_RESTORE_VERIFYONLY @filename='[file_path']
2. The restore server's version of LiteSpeed must be at least the same or higher than the one on the backup machine.
LiteSpeed is backward compatible. You can backup on the old and restore on the new, but not vice versa.
To determine the Version of LiteSpeed, in Query Analyzer execute the query ( EXEC xp_sqllitespeed_version) on both SQL Servers. Also, if using statistics, the Local and Central Repository must be on the higher (more recent) version of LiteSpeed. See Solution 20511
Extract the LiteSpeed 2005 backup Northwind.bak to native SQL Server backup NorthwindNative.bak :
extractor.exe -F'c:tempNorthwind.bak' -E'c:tempNorthwindNative.bak' -N1 -L2
This generates native SQL Server backup files. You can restore from them using native SQL Server RESTORE commands.
LiteSpeed Extractor will create the same number of native SQL Server files as the thread count for the original backup. Use the following script in Query Analyzer to restore the files using as a striped backup:
restore database northwind
from
disk='d:\backup\NorthwindNative.bak0',
disk='d:\backup\NorthwindNative.bak1',
disk='d:\backup\NorthwindNative.bak2'
