Best backup compression tools

Question

Post reply

Best backup compression tools

Mh-397891

SSCertifiable

Points: 6704
More actions
February 20, 2008 at 1:54 pm

#182357

We are planning to buy backup compression tool, please suggest which one will be good. Thanks!!

Viewing 15 posts - 1 through 14 (of 14 total)

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

SQL ORACLE One Orange Chip Points: 27807 More actions · Answer 1

SQL ORACLE

One Orange Chip

Points: 27807

February 20, 2008 at 8:52 pm

#780486

How about LiteSpeed?

Steve Jones - SSC Editor SSC Guru Points: 736193 More actions · Answer 2

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.

EdVassie SSC Guru Points: 60472 More actions · Answer 3

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

utsabchattopadhyay SSC Enthusiast Points: 170 More actions · Answer 4

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

http://www.consultdba.com

Tommy Bollhofer SSChampion Points: 14940 More actions · Answer 5

Have you looked at Idera's SQLSafe freeware editon?

http://www.idera.com/Products/SQLsafefree/Default.aspx

Tommy

Follow @sqlscribe

tosscrosby SSCoach Points: 18045 More actions · Answer 6

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.

barsuk SSChampion Points: 12280 More actions · Answer 7

LiteSpeed is good, you could toggle different levels of compression, so to increase\decrease backup time and to decrease\increase space utilized for that.

Joseph-465703 SSCrazy Points: 2122 More actions · Answer 8

are you planning to take object-level backups which means taking backup of individual tables, views etc...

then Quest SQLiteSpeed is good.

Vivien Xing SSChampion Points: 12297 More actions · Answer 9

Any one use Idera's SQLSafe "freeware" editon for production databases? Is the freeware a good option for production?

tosscrosby SSCoach Points: 18045 More actions · Answer 10

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.

subbarayudu.net 37258 Mr or Mrs. 500 Points: 540 More actions · Answer 11

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.

barsuk SSChampion Points: 12280 More actions · Answer 12

You can start from here:

http://www.sqlservercentral.com/articles/Product+Reviews/litespeedforsqlserver/1862/

drew01182 Valued Member Points: 60 More actions · Answer 13

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.

B's-Data SSChasing Mays Points: 607 More actions · Answer 14

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.