Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restore from LiteSpeed Expand / Collapse
Author
Message
Posted Monday, October 11, 2010 10:00 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 357, Visits: 1,716
Comments posted to this topic are about the item Restore from LiteSpeed

blog: http://sarveshsingh.com

Twitter: @sarveshsing
Post #1002535
Posted Monday, October 11, 2010 10:10 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 15, 2013 12:27 PM
Points: 11, Visits: 50
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
Posted Tuesday, October 12, 2010 3:02 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 1:17 AM
Points: 477, Visits: 1,903
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
Posted Tuesday, October 12, 2010 4:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, November 21, 2014 12:12 PM
Points: 5,615, Visits: 6,413
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

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
Posted Tuesday, October 12, 2010 8:07 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 357, Visits: 1,716
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
Posted Tuesday, October 12, 2010 12:50 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, October 13, 2010 6:08 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
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
Posted Wednesday, October 13, 2010 6:18 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 15, 2013 12:27 PM
Points: 11, Visits: 50
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
Posted Thursday, October 14, 2010 6:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, November 21, 2014 12:12 PM
Points: 5,615, Visits: 6,413
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 Administrator

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 »

Add to briefcase

Permissions Expand / Collapse