Litespeed to restore native sql backups

Question

Post reply

Litespeed to restore native sql backups

Roust_m

SSCoach

Points: 17408
More actions
February 2, 2014 at 10:09 pm

#287886

Hi,
I need to be able to restore some native compressed backups with litespeed. The reason being, we have very complex test environment build process and want to add more databases to the process without buying more litespeed licenses and changing the process.
The litespeed version we have now is 5.0.1.1060. When I try to restore a native backup, I am getting this error:
Msg 60403, Level 19, State 0, Line 0
Not a valid LiteSpeed format file (Type is: 1).
You must select a valid LiteSpeed file to append backups or use the @init option to delete the file.
I've downloaded the most recent version of Litespeed: LiteSpeed(R) for SQL Server Version 7.5.2.31 (64bit)
It would restore native backups with no error. The problem is it would not accept our license key we have already.
So my question is, what is the latest version of Litespeed, which would restore SQL Server 2008 R2 native compressed backups?
Thanks.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 1

Litespeed doesn't restore native backups. All it does is use the same native restore TSQL you run through SSMS.

Attempting to restore a native backup using the Litespeed xp's will result in this kind of error.

SQLBlimp SSCertifiable Points: 6340 More actions · Answer 2

Roust_m (2/2/2014)
Hi,
I need to be able to restore some native compressed backups with litespeed. The reason being, we have very complex test environment build process and want to add more databases to the process without buying more litespeed licenses and changing the process.
The litespeed version we have now is 5.0.1.1060. When I try to restore a native backup, I am getting this error:
Msg 60403, Level 19, State 0, Line 0
Not a valid LiteSpeed format file (Type is: 1).
You must select a valid LiteSpeed file to append backups or use the @init option to delete the file.
I've downloaded the most recent version of Litespeed: LiteSpeed(R) for SQL Server Version 7.5.2.31 (64bit)
It would restore native backups with no error. The problem is it would not accept our license key we have already.
So my question is, what is the latest version of Litespeed, which would restore SQL Server 2008 R2 native compressed backups?
Thanks.

Litespeed 7.0 is the oldest version that will restore a native SQL Server backup. Time to contact Dell (they bought Quest out) and update your licenses.

Thanks

John

DeWayne_McCallie Hall of Fame Points: 3617 More actions · Answer 3

I don't know if this will help or not; however, you can convert a lightspeed backup file to a SQL native backup file using the lightspeed extractor.exe command in a dos window. You should be able to use Lightspeed or SQL Native backup/restore on any SQL instance that has lightspeed installed. I am not sure about LS version 5 though.

Roust_m SSCoach Points: 17408 More actions · Answer 4

JohnFTamburo (2/3/2014)
Roust_m (2/2/2014)
Hi,
I need to be able to restore some native compressed backups with litespeed. The reason being, we have very complex test environment build process and want to add more databases to the process without buying more litespeed licenses and changing the process.
The litespeed version we have now is 5.0.1.1060. When I try to restore a native backup, I am getting this error:
Msg 60403, Level 19, State 0, Line 0
Not a valid LiteSpeed format file (Type is: 1).
You must select a valid LiteSpeed file to append backups or use the @init option to delete the file.
I've downloaded the most recent version of Litespeed: LiteSpeed(R) for SQL Server Version 7.5.2.31 (64bit)
It would restore native backups with no error. The problem is it would not accept our license key we have already.
So my question is, what is the latest version of Litespeed, which would restore SQL Server 2008 R2 native compressed backups?
Thanks.
Litespeed 7.0 is the oldest version that will restore a native SQL Server backup. Time to contact Dell (they bought Quest out) and update your licenses.
Thanks
John

This is not correct, as version 5 will restore native SQL Server backups which are not compressed, version 7 will restore compressed ones. We are moving away from Litespeed, as the functionality exists in SQL Server. Just need to make that move gradual.

Roust_m SSCoach Points: 17408 More actions · Answer 5

All Litespeed versions would restore native backups btw, it is a matter of it the version is current enough for the SQL Server version. Version 5 is not compatible with the backup compression feature of SQL Server 2008 R2, but would restore not compressed backups just fine.