October 11, 2010 at 10:00 pm
Comments posted to this topic are about the item Restore from LiteSpeed
October 11, 2010 at 10:10 pm
Extracting the LiteSpeed backup to turn it into a native backup when needed is useful if LiteSpeed is not installed on any available server. I wanted to add that you might find using Double Click Restore (DCR) is an easier way to restore a LiteSpeed backup on a server where LiteSpeed is not installed. DCR allows you to take a backup and turn it into an EXE. Starting in LiteSpeed 6.0, you can still do this at backup time, but you can also use the DCR extended stored procedure or command line to take an existing backup and turn it into an EXE. The EXE includes a simple UI to perform the restore. Of course this requires you have access to LiteSpeed somewhere in order to run the procedure. If not, extracting is the next best option. Thanks for the post.
--
David
--
David Gugick
Dir. Architecture & Design, Quest Software
October 12, 2010 at 3:02 am
If your Backupfile contains more then 1 backups (perhaps you did back up all Databases in one go) you need to add the filenumber to the command line for the extraction:
-N Filenumber
regards
karl
Best regards
karl
October 12, 2010 at 4:14 am
If you're going to use the backup on another server, rather than the server the backup was saved to, I recommend moving the backup file *before* converting it to a native SQL backup. Litespeed is commonly used because of its compression capabilities and conversions of backup files tend to "re-inflate" the file(s).
If you don't move it first, it will take much longer to move it after conversion.
October 12, 2010 at 8:07 am
Thanks for the feedback guys. Much appreciated.
If your Backupfile contains more then 1 backups (perhaps you did back up all Databases in one go) you need to add the filenumber to the command line for the extraction:
-N Filenumber
You are rite Karl. My backup file had only one backup. Point taken about adding the -N filenumber to the command line
October 12, 2010 at 12:50 pm
Don't forget to include the correct platform version of EXTRACTOR.EXE if you are going to extract the backup file on a different server than the backup was made on. The x64 version of EXTRACTOR.EXE won't run on an x86 operating system. I can't remember if the reverse is true or not.
October 13, 2010 at 6:08 pm
Is the extractor utility available to people that don't have a LiteSpeed license? (For example if someone is sending me a backup they created using LiteSpeed and I need to restore it, but don't own LiteSpeed.)
October 13, 2010 at 6:18 pm
What you're describing is a good use case for Double Click Restore. Then you can restore the compressed/encrypted LiteSpeed backup without having to extract to native size and format or needing to install LiteSpeed. Having said that, if you ever ran into a situation where you needed to extract a LiteSpeed backup but did not own LiteSpeed, you could download and install the LiteSpeed trial. Restoring is not licensed functionality, so you can use LiteSpeed to restore without an issue. Once installed, if you wanted, you could use the Extractor or restore from the UI/Extended Stored Procs/Command Line if you installed LiteSpeed on an instance.
--
David Gugick
Dir. Architecture & Design, Quest Software
October 14, 2010 at 6:37 am
UMG Developer (10/13/2010)
Is the extractor utility available to people that don't have a LiteSpeed license? (For example if someone is sending me a backup they created using LiteSpeed and I need to restore it, but don't own LiteSpeed.)
Yes, it is. You should contact Quest for more details.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply