Restore from LiteSpeed

  • Comments posted to this topic are about the item Restore from LiteSpeed

  • 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

  • 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

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • 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

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

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

  • 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

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

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 9 posts - 1 through 9 (of 9 total)

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