February 20, 2008 at 1:54 pm
We are planning to buy backup compression tool, please suggest which one will be good. Thanks!!
February 20, 2008 at 8:52 pm
How about LiteSpeed?
February 20, 2008 at 9:52 pm
They are all good. Litespeed (Quest), SQL Backup (Red Gate), SQL Safe (Idera), and Hyperbac's tool.
Pick the one that seems suited to your environment and has the features you need.
February 22, 2008 at 3:22 am
It is far better to buy a tool that creates a compressed backup than a tool that compresses a standard SQL Server backup.
All the tools I know of that create a compressed backup run faster than the standard SQL backup. Also, you only need the disk space required for the finished backup.
If you get a file compress tool, this can only start work after the SQL backup has finished. You need enough disk space to hold the uncompressed backup plus the compressed version. Getting a script to reliably do the compress is harder than it apears.
Steve has given good advice - each backup product has its own strengths, you need to choose what fits your needs best.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 25, 2008 at 1:15 pm
I would vote for Lightspeed or Redgate as they are well tested in many enterprises.
If you can wait.. Katmai has it's own compression. Maybe that will help you guys (Thouhg I doubt how practical it is for that considering it will takes long time before migration)
Regards
Utsab Chattopadhyay
February 25, 2008 at 1:22 pm
Have you looked at Idera's SQLSafe freeware editon?
http://www.idera.com/Products/SQLsafefree/Default.aspx
Tommy
Follow @sqlscribeFebruary 26, 2008 at 1:00 pm
I've used Lightspeed for years and recently SqlSafe (due to overall costs). Both worked well for compression and SQLSafe for encryption (didn't use that feature in Lightspeed). Backup and restore times and compressed file sizes for each product were very similiar.
-- You can't be late until you show up.
February 26, 2008 at 5:34 pm
LiteSpeed is good, you could toggle different levels of compression, so to increase\decrease backup time and to decrease\increase space utilized for that.
February 26, 2008 at 7:22 pm
are you planning to take object-level backups which means taking backup of individual tables, views etc...
then Quest SQLiteSpeed is good.
May 21, 2008 at 6:14 pm
Any one use Idera's SQLSafe "freeware" editon for production databases? Is the freeware a good option for production?
May 22, 2008 at 6:44 am
It all depends on what you need to do. Here is a link to side-by-side comparisons of the paid version and freeware (paid is relatively inexpensive!). You can't do encryption, compression is for speed only, not size, no wizards, no table level restores, no support...I guess it depends on what your needs truly are. For normal backups and restores with compression, it should be fine.
http://www.idera.com/Products/SQLsafefree/
-- You can't be late until you show up.
February 12, 2010 at 4:03 am
I am Innocent in the LightSpeed Tool, becasue in my environment I am not using that, but now i am looking to change. So interviewr asking these types of third party tools please help me in details fashion. What probs u r facing when using this tool. what is the benifits of it.
How to work LightSpeed ? and how to intigrate with sql server ? how to work with LightSpeed, Please give the details information about LightSpeed.
I need the information [ LightSpeed ] from scratch.
Subbu.
February 12, 2010 at 12:21 pm
You can start from here:
http://www.sqlservercentral.com/articles/Product+Reviews/litespeedforsqlserver/1862/
February 8, 2013 at 9:37 am
I highly recommend Red Gate SQLBackup. Last I checked, pricing was much more reasonable and performs just as well if not better. It also supports object level recovery.
March 26, 2013 at 2:31 pm
I am using IDERA SQLSafe and have found it to be a great tool to use for compressed backups. It runs rather quickly. I have not been using the free version. I have used Lightspeed and have found it to be good as well. I am using the IDERA version because I also use IDERA's virtual database software which is awesome. It restores their backup very very fast. I tested Redgate and found it to take at least twice as long as IDERA. The only issue I have with IDERA is their tech support leaves a lot to be desired, but I've seen worse.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply