Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Restore from LiteSpeed

By Sarvesh Singh,

There will be occasions when you will need to recover native backup file from the file which has been compressed by Litespeed. I received the following error message when trying to restore a database at a customer site.

 

 

This is because I was trying to restore a database that was compressed by Litespeed software. In this article i will explain below how to restore the database by following two 2 simple steps using Quest's extractor utility.

STEP1

Open a Command Prompt and navigate to the location where Quest's Utility extractor.exe is located. The command to extract the native backup file is as shown below:

extractor.exe -F (Path where Litespeed backup is) -E (Path where you would like to extract the backup).

For example, if your litespeed backup was located in E:\Samplebackups\Sample_Full.bak and you wanted to extract the files in this same directory with new file names then you would run the command as shown in the screenshot below.

 


Once this command is run you will see multiple files extracted, as Litespeed creates a file for each thread when a backup is taken. So you will see files extracted as shown in the screenshot below. Here Sample_Full.bak is the litespeed backup and the rest of the 7 files are the extracted files.

 

Now that the Files have been extracted, the next step is to Restore the database using these files.

Step 2

You can restore the database using these files by running TSQL or SSMS. The syntax to restore using TSQL is as follows.

RESTORE DATABASE [Sample]
FROM DISK = 'E:\Sample_Full_ext.bak0',
DISK = 'E:\Sample_Full_ext.bak1',
DISK = 'E:\Sample_Full_ext.bak2',
DISK= 'E:\Sample_Full_ext.bak3',
DISK='E:\Sample_Full_ext.bak4',
DISK='E:\Sample_Full_ext.bak5',
DISK='E:\Sample_Full_ext.bak6'
With Recovery
Go


If you are using SSMS then you will need to add the extracted files as shown in the screenshot below. Once all the files are added click OK. Then select your restore point and click OK.

The database will get restored without any error message.

Total article views: 4632 | Views in the last 30 days: 11
 
Related Articles
ARTICLE

Using DMO to Restore a Database

This article by Andy Warren includes code samples showing you how to restore a database from a file ...

FORUM

database backup and restore in sql server 2005

database backup and restore using java

FORUM

Backup/restore

Backup/restore

FORUM

Restore from Backup with Replicated Database

Restore from Backup with Replicated Database

FORUM

SQL 2005 Sample Databases

Sample Databases

Tags
backup / restore    
litespeed    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones