-
Title
How to restore LiteSpeed backup file to server with earlier version of LiteSpeed -
Description
Backup and restore using LiteSpeed is backward compatible. A Backup file created on an earlier version of LiteSpeed can be restored on a more recent (higher or later version) of LiteSpeed, but not vice versa.
-
Resolution
The LiteSpeed file may be converted to a native SQL Server format and restored using the native function, using a three step process.
1. Backup using LiteSpeed
2. Extract backup file to native SQL Server format
3. Restore using SQL Server.
Example:
Backup created using LiteSpeed 5.2
exec master.dbo.xp_backup_database @database = N'Pubs', @filename = N'D:\Backup\2005\Pubs201111060648LiteSpeed_Full.BKP', @backupname = N'Pubs backup', @desc = N'Backup of Pubs on 2007-11-06 06:48:32', @with = N'SKIP', @with = N'STATS = 10'
From the Windows TaskBar: Start | Run | cmd
H:\>cd C:\Program Files\Imceda\LiteSpeed\SQL Server
H:\>C:
C:\Program Files\Imceda\LiteSpeed\SQL Server>extractor.exe -FD:\Backup\2005\Pubs201111060648LiteSpeed_Full.BKP -Ed:\backup\PubsNative.bak -N1
Version
Extractor Utility.
Successfully extracted the LiteSpeed format to the native SQL Server backup formatted files (MTF).
The extracted files can be restored with the native SQL Server restore commands.
Please consult the SQL Server documentation for the appropriate restore information.
Files created by extraction process:
D:\Backup>dir
Volume in drive D is DATA
Directory of D:\Backup
11/06/2007 06:52 AM <DIR> .
11/06/2007 06:52 AM <DIR> ..
11/06/2007 06:52 AM 1,769,472 PubsNative.bak0
11/06/2007 06:52 AM 1,638,400 PubsNative.bak1
11/06/2007 06:52 AM 1,638,400 PubsNative.bak2
In Query Analyzer (native SQL Server command):
restore database Pubs
from
disk='d:\backup\PubsNative.bak0',
disk='d:\backup\PubsNative.bak1',
disk='d:\backup\PubsNative.bak2' -
Additional Information
The versions of SQL Server must be the same between the source and destination servers.