Best backup compression tools

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » Best backup compression tools

15 posts, Page 1 of 2

1 2 »»

Best backup compression tools

Rate Topic

Display Mode

Topic Options

Author

Message

Mh-397891

Posted Wednesday, February 20, 2008 1:54 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 2:28 PM
Points: 261, Visits: 1,492

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

Post #458210

SQL ORACLE

Posted Wednesday, February 20, 2008 8:52 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 2013 4:43 PM
Points: 1,473, Visits: 1,314

How about LiteSpeed?

Post #458337

Steve Jones - SSC Editor

Posted Wednesday, February 20, 2008 9:52 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:04 PM
Points: 31,418, Visits: 13,731

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #458350

EdVassie

Posted Friday, February 22, 2008 3:22 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 7:57 AM
Points: 2,621, Visits: 2,758

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.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.

Post #458992

utsabchattopadhyay

Posted Monday, February 25, 2008 1:15 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 25, 2008 1:00 PM
Points: 8, Visits: 23

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
www.consultdba.com

Post #459917

Tommy Bollhofer

Posted Monday, February 25, 2008 1:22 PM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 PM
Points: 1,148, Visits: 3,148

Have you looked at Idera's SQLSafe freeware editon?

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

Tommy

Post #459924

tosscrosby

Posted Tuesday, February 26, 2008 1:00 PM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 7:31 AM
Points: 2,832, Visits: 5,316

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.

Post #460502

barsuk

Posted Tuesday, February 26, 2008 5:34 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 7:26 PM
Points: 2,642, Visits: 4,960

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

Post #460631

Joseph-465703

Posted Tuesday, February 26, 2008 7:22 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 06, 2012 10:04 AM
Points: 144, Visits: 455

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

Post #460654

Vivien Xing

Posted Wednesday, May 21, 2008 6:14 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 7:19 AM
Points: 1,279, Visits: 2,191

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

Post #504923

« Prev Topic | Next Topic »

15 posts, Page 1 of 2

1 2 »»

Permissions