February 20, 2010 at 9:30 am
How does SQL Server 2008 Backup Compression perform compared to Litespeed & Redgate's product?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 20, 2010 at 10:16 am
They all compress things, but the SQL Server native compression is on/off only (http://msdn.microsoft.com/en-us/library/bb964719.aspx). Both Litespeed and Red Gate allow varying levels of compression, which allows you to trade off space/time for CPU usage.
We use RG here, but we're owned by Red Gate. In the early years of this site, we used litespeed. Both work, but to me they're toasters. Both do the job.
In a company I worked on, we used Litepseed, the original product (v1, and v2) and we set a mid level compression for most servers, but a light setting on a server that was used constantly and we didn't want the CPU hit from the product.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
February 20, 2010 at 11:14 am
I have only used Lightspeed.
I was not sure what meant by:
but a light setting on a server that was used constantly and we didn't want the CPU hit from the product.
Are you saying that the product puts a load on the Sever regardless of whether you are backing up or restoring?
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 20, 2010 at 11:22 am
At the time we had 3 compression settings (light, medium, high). They result in (in order), less compression, good compression, heavy compression, meaning most disk space, middle, least disk space.
If you run performance counters, we found a surprising CPU hit on the server. There's no free lunch, compression requires CPUs. I know in the newer products there are more settings for using parallel CPUs (or not) or perhaps balancing priority. We would use less compression, and less CPU, on one server, just because we had some loads on that server overnight.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 27, 2010 at 1:57 pm
Do you know of any file converter program that will convert a litespeed backup file to a format that RedGate will recognize and use?
Joe
May 27, 2010 at 2:03 pm
Both programs convert to native, which all can use.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 27, 2010 at 2:05 pm
Well, I have a LiteSpeed backup and no LiteSpeed program. I have Red Gate software and SQL Backup will not even touch it. Any ideas?
May 27, 2010 at 2:26 pm
You could download a trial of Litespeed, which has the extractor.exe program to convert to native backup format.
I'll ping people and see if I can find a licensed copy.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 27, 2010 at 2:57 pm
Yep, you need to grab the trial version, use restore only mode.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 12, 2010 at 9:53 am
Does anyone know the cost of owning LiteSpeed? I noticed on their website they have developer edition for $200, however initially we would need LS on a Prod server backing up 500GB+ dbs and restoring them on a dev/test server. Would I need two copies of LS, one standard and one dev?
Thanks
qh
July 12, 2010 at 12:09 pm
quackhandle1975 (7/12/2010)
Does anyone know the cost of owning LiteSpeed? I noticed on their website they have developer edition for $200, however initially we would need LS on a Prod server backing up 500GB+ dbs and restoring them on a dev/test server. Would I need two copies of LS, one standard and one dev?Thanks
qh
I think the most reliable answer about current pricing & licensing would be from Litespeed.
July 12, 2010 at 12:30 pm
quackhandle1975 (7/12/2010)
Does anyone know the cost of owning LiteSpeed? I noticed on their website they have developer edition for $200, however initially we would need LS on a Prod server backing up 500GB+ dbs and restoring them on a dev/test server. Would I need two copies of LS, one standard and one dev?Thanks
qh
It used to be (5 or so years ago) that you needed one copy for production and then install the restore agent on the dev server, free of charge - couldn't do backups on Dev. Again, it's been a while and licensing may have changed.
-- You can't be late until you show up.
July 12, 2010 at 2:56 pm
Quote Date: 7/10/2007
Standard Version
1 LITESPEED FOR SQL SERVER TIER A LICENSE/MAINT
2 $2,490.00
LSS-IMC-PB-TRA
$1,245.00
2 LITESPEED FOR SQL SERVER NON PROD TIER A
LICENSE/MAINT
2 $1,300.00
LSS-IMC-PB-NPNTRA
$650.00
Subtotal
Total $4,055.30
Quote Date: 7/10/2007
Enterprise Version
1 LITESPEED ENTERPRISE FOR SQL SERVER TIER A
LICENSE/MAINT
2 $3,590.00
LSP-IMC-PB-TRA
$1,795.00
2 LITESPEED ENTERPRISE FOR SQL SERVER NON PROD TIER A
LICENSE/MAINT
2 $1,790.00
LSP-IMC-PB-NPNTRA
$895.00
Subtotal
Total $5,756.60
Estimated Tax
$5,380.00
$376.60
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 12, 2010 at 3:45 pm
The easiest way to get pricing is to contact a sales rep over at Quest who will be happy to quote you on the product. There are different versions of LiteSpeed available and in an effort to get you the correct pricing for the product you need, please either call us at (800) 306-9329 or email us at info@quest.com.
Thanks
--
David Gugick
Dir. Architecture & Design, Quest Software
--
David Gugick
Dir. Architecture & Design, Quest Software
July 12, 2010 at 3:49 pm
You do not require a LiteSpeed license to perform a restore. In fact, you don't even need LiteSpeed installed on the instance if you use our Double-Click Restore technology which can either backup up a database to an EXE format or convert an existing backup to an EXE format. The backups can then be restored to any SQL Server whether or not LiteSpeed is installed. The other options are to use our Extractor to convert a LiteSpeed backup to a native backup or you can install LiteSpeed in Restore-Only mode giving you the ability to perform restore operations with UI support.
Thanks.
--
David Gugick
Dir. Architecture & Design, Quest Software
--
David Gugick
Dir. Architecture & Design, Quest Software
Viewing 15 posts - 31 through 45 (of 50 total)
You must be logged in to reply to this topic. Login to reply