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 12»»

Best backup compression tools Expand / Collapse
Author
Message
Posted Wednesday, February 20, 2008 1:54 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
We are planning to buy backup compression tool, please suggest which one will be good. Thanks!!
Post #458210
Posted Wednesday, February 20, 2008 8:52 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314
How about LiteSpeed?
Post #458337
Posted Wednesday, February 20, 2008 9:52 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 5:59 PM
Points: 31,082, Visits: 15,529
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
Posted Friday, February 22, 2008 3:22 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:38 AM
Points: 2,880, Visits: 3,237
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,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
Posted Monday, February 25, 2008 1:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, February 25, 2008 1:22 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:39 AM
Points: 1,157, Visits: 3,264
Have you looked at Idera's SQLSafe freeware editon?

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


Tommy

Post #459924
Posted Tuesday, February 26, 2008 1:00 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 19, 2011 7:31 AM
Points: 2,666, 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
Posted Tuesday, February 26, 2008 5:34 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:57 PM
Points: 3,156, Visits: 5,992
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
Posted Tuesday, February 26, 2008 7:22 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 6, 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
Posted Wednesday, May 21, 2008 6:14 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 8, 2014 2:49 PM
Points: 1,278, Visits: 2,203
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 »

Add to briefcase 12»»

Permissions Expand / Collapse