How to convert LiteSpeed backup to a native SQL backup ?

Leave a comment (0) Go to comments

SQL Lite Speed is a well known SQL backup software. At times it is requirement to restore a SQL database on some server where SQL Lite speed is not installed from a backup file, which was created using SQL LIte Speed. This is what I got as an requirement where I need to send a SQL Server backup file which was created a month back to a different business unit, where SQL Lite speed was not used.

Now there is requirement for converting a  SQL LiteSpeed backup file to a native SQL backup file.

I knew that there was a utility called Extractor for LiteSpeed which can convert the LiteSpeed backups into native SQL backups.

Parameters:

-F|–BackupFile {path}        Path of the backup or restore file devices

-N|–BackupIndex  {n}       File number (If multiple backups appended within BackupFile(s))

-E|–MTFFile {path}            Path of the Microsoft Tape Format file(s) to be written.  Specify either one or the correct number of files.  If only one file is named, set will be created with index suffixes. If no files listed, Extractor will print number of MTF files to be written.

-K|–Key {key}                 String used to decrypt database backup file(s) Only required if backup is encrypted.
-I|–Overwrite                   Overwrite MTFFile(s). Equivalent of INIT in native SQLServer backups


-L|–LogLevel {n}              Logging option

Example:

 Extractor.exe -FC:\LiteSpeedTran.BKP -EC:\NativeBackup.BKP -N1

NOTE: To use Extractor utility, you do not need LiteSpeed to be installed on the box. (But the licensing policies and EULA still apply if you are using Extractor)

How to get backup header information for LiteSpeed backups

If you have LiteSpeed installed on your box, then you can executed the following XSP command to get a RESTORE HEADERONLY output for a LiteSpeed backup file. This will give a similar output that the T-SQL command RESTORE HEADERONLY provides:

 exec master.dbo.xp_restore_headeronly @filename =  'C:\LiteSpeedTran.BKP'

Tags : sql server lite speed, sql litespeed,How to convert a LiteSpeed backup into a native SQL backup,Extractor.exe,xp_restore_headeronly,Extractor for LiteSpeed ,restore sql database from sql litespeed backup file,Convert LiteSpeed Backups to SQL Server Backups and restore them,SQL Server Backup and Restore, back to basics with SQL Litespeed,SQL Litespeed vs. Native SQL Backups,restore sql database from sql litespeed backup file,How do I restore a an SQL database

EOF - How to convert LiteSpeed backup to a native SQL backup ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.