Restore from LiteSpeed

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sarvesh Singh » Restore from LiteSpeed

Restore from LiteSpeed

Rate Topic

Display Mode

Topic Options

Author

Message

ss-457805

Posted Monday, October 11, 2010 10:00 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 2:40 AM
Points: 356, Visits: 1,667

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

blog: http://sarveshsingh.com

Twitter: @sarveshsing

Post #1002535

David Gugick

Posted Monday, October 11, 2010 10:10 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, April 13, 2012 8:33 AM
Points: 11, Visits: 46

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

Post #1002537

Karl Klingler

Posted Tuesday, October 12, 2010 3:02 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:26 AM
Points: 475, Visits: 1,690

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

Post #1002616

Brandie Tarvin

Posted Tuesday, October 12, 2010 4:14 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 6,724, Visits: 5,796

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 Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1002652

ss-457805

Posted Tuesday, October 12, 2010 8:07 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 2:40 AM
Points: 356, Visits: 1,667

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

blog: http://sarveshsingh.com

Twitter: @sarveshsing

Post #1002841

Doug Piercy

Posted Tuesday, October 12, 2010 12:50 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 14, 2013 10:22 AM
Points: 3, Visits: 171

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.

Post #1003133

UMG Developer

Posted Wednesday, October 13, 2010 6:08 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 2,163, Visits: 2,151

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

Post #1004064

David Gugick

Posted Wednesday, October 13, 2010 6:18 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, April 13, 2012 8:33 AM
Points: 11, Visits: 46

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

Post #1004071

Brandie Tarvin

Posted Thursday, October 14, 2010 6:37 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:57 AM
Points: 6,724, Visits: 5,796

UMG Developer (10/13/2010)

Yes, it is. You should contact Quest for more details.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1004301

« Prev Topic | Next Topic »

Permissions