SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Sarvesh Singh / Restore from LiteSpeed / Latest Posts

RE: Restore from LiteSpeed

Brandie Tarvin — Thu, 14 Oct 2010 06:37:18 GMT

[quote][b]UMG Developer (10/13/2010)[/b][hr]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.)[/quote]Yes, it is. You should contact Quest for more details.

RE: Restore from LiteSpeed

David Gugick — Wed, 13 Oct 2010 18:18:33 GMT

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.

RE: Restore from LiteSpeed

UMG Developer — Wed, 13 Oct 2010 18:08:28 GMT

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.)

RE: Restore from LiteSpeed

Doug Piercy — Tue, 12 Oct 2010 12:50:35 GMT

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.

RE: Restore from LiteSpeed

ss-457805 — Tue, 12 Oct 2010 08:07:03 GMT

Thanks for the feedback guys. Much appreciated.[quote]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[/quote]You are rite Karl. My backup file had only one backup. Point taken about adding the -N filenumber to the command line

RE: Restore from LiteSpeed

Brandie Tarvin — Tue, 12 Oct 2010 04:14:20 GMT

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.

RE: Restore from LiteSpeed

Karl Klingler — Tue, 12 Oct 2010 03:02:44 GMT

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 Filenumberregardskarl

RE: Restore from LiteSpeed

David Gugick — Mon, 11 Oct 2010 22:10:41 GMT

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

Restore from LiteSpeed

ss-457805 — Mon, 11 Oct 2010 22:00:20 GMT

Comments posted to this topic are about the item [B]Restore from LiteSpeed[/B]