-
Title
How to restore a backup created with Version 4.5 to a server with Version 6.x? -
Description
How to restore a backup created with Version 4.5 to a server with Version 6.x? Files create in Version 4.5 are restoreable in Version 5.x
If the source server has LiteSpeed for SQL Server verison 4.5, the backups cannot be restored by Version 6.x of LiteSpeed (by design, this is not a defect). This process will fail for restore database, restore headeronly or restore verifyonly.
The error message will display: The file on device 'F:\Programs\mssql\backup\Backup_from_Prod\FDM8QA_LS_Full_data' is not a valid Microsoft Tape Format backup set.
-
Cause
N/A
-
Resolution
WORKAROUND1:
If the sqllitespeed.exe from the 4.5 version was saved to the new server as sqllitespeed_old.exe, you would use a command line such as this example:sqllitespeed_old.exe -RDatabase -F"D:\Backup\2005\Northwind\Northwind_201006141439.bak" -N1 -D "Northwind" -WREPLACE -W"MOVE 'Northwind' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Northwind.mdf'" -W"MOVE 'Northwind_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Northwind_log.ldf'" -A0 -S"servername\instancename" -T
WORKAROUND2:
Use the Version 4.5 extractor to return the file to a SQL Server format and restore as a native file. The verison of the extractor.exe must be the same as the version that created the backup file.For additional ifno, see https://support.quest.com/Search/SolutionDetail.aspx?id=SOL36366