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

SQL Server 2005 Backup Third Party Tools Expand / Collapse
Author
Message
Posted Tuesday, January 29, 2008 2:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 6:27 PM
Points: 39, Visits: 419
I am interested in obtaining a tool for database backup/recovery with compression and encryption that is cluster aware. I am mainly concerned with decreasing the time required for backup/restore of large databases. Compression is important as well, but not as critical as time. It seems that SQL Backup by Red Gate and LiteSpeed from Quest are the two products that fit my requirements.

I would like to hear opinions from members who have had experience with one or both of these or other tools. Specifically I would like to know the amount of improvement in both time and size between SQL Server native client backup/restore operations and these tools. I am operating on a Windows 2003 cluster with SQL Server 2005.



Post #449096
Posted Wednesday, January 30, 2008 6:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 4:45 AM
Points: 2,385, Visits: 1,843
Microsoft itself is using Lightspeed to backup their VLDB databases. Hence I won't hesitate to go with Lightspeed.

But if you are looking something more beyond only Backup/Restore and to have SQL TOOLS you can think about Redgate. I guess both will give more or less similar performance.


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #449316
Posted Wednesday, January 30, 2008 7:58 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:38 PM
Points: 318, Visits: 345
Of the many vendors out there, to my knowledge LiteSpeed is the only one cluster aware. A couple of the others try to be, but they're really not. You can run them on a cluster, but it takes some effort, whereas litespeed IS cluster aware and installs like a dream.

Watch my free SQL Server Tutorials at:
http://MidnightDBA.ITBookworm.com

Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://www.infoworld.com/blogs/sean-mccown
DBA Rant – http://dbarant.blogspot.com
Post #449408
Posted Thursday, January 31, 2008 8:32 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 12:46 PM
Points: 1,413, Visits: 4,531
we currently use Veritas Netbackup and we are looking to go to Evault in the next few months. EMC also owns Avamar which was OK, but very buggy when we tested it a few years back before they got bought out. Evault is pretty good, but buggy as well

https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #449988
Posted Thursday, January 31, 2008 9:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 30, 2008 10:55 AM
Points: 10, Visits: 28
I've used both Red Gate and LiteSpeed products. As far as compression and speed, they are pretty much the same. LiteSpeed product has far more bells and whistles to go along with it, much of them I never touch. LiteSpeed is the only Cluster aware product. It's also far more expensive. I'd go with Red Gate if it's only for compression and speed, but if you have any other needs you might as well get the best product available - LiteSpeed.
Post #450011
Posted Thursday, January 31, 2008 9:01 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 4:33 PM
Points: 2,139, Visits: 638
Hi,

Currently using Litespeed for backup of 1TB+ database, which compresses down to 103GB within 2hrs, which is pretty good. Depending on your RTO, this may fit or may not, but if your requirement is shorter and your database infrastructure is supported by a SAN, you should look at using SAN vendor Snapshot technology, which works at the block level for backups and restores.

Hope this helps,
Phillip Cox
Post #450012
Posted Thursday, January 31, 2008 9:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 30, 2008 10:55 AM
Points: 10, Visits: 28
The times and size saved are pretty much the same fo rboth products. I've seen 70% in space savings as well as 50% in time saved running the backup (in both products). It really depends on your DB's. If you have many texts or blog fields, the backup may take LONGER then native because these fields can not be compressed, but the product still ttys to do it.
Post #450018
Posted Thursday, January 31, 2008 9:46 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 11:32 PM
Points: 343, Visits: 1,515
Red Gates' SQL Backup has a nice transaction log restore feature, where you could just pass something like this:

EXEC master..sqlbackup '-sql "RESTORE LOG mydb FROM DISK = [e:\backups\mydb*.sqb] WITH RECOVERY"'

and it will pick up all the transaction log backup files in the e:\backups folder matching the search pattern, sort them, and restore each backup set in the right sequential order. Beats having to restore each transaction log backup set individually, which is error prone and time consuming when you have a lot of logs to restore.

Also, SQL Backup does this by reading the backup details from each files' header, so you don't need access to the backup servers' msdb database, which means you can use this feature on any standby server.


Ray Mond

TLogInfo - the only FREE tool to analyse your transaction logs. Download here.
SQL BAK Reader - the only FREE tool to inspect your SQL Server backup files without using SQL Server. Download here.
Post #450298
Posted Friday, February 01, 2008 1:35 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 1:53 PM
Points: 1,030, Visits: 2,791
I've only really used Redgate's SQL backup aside from the native client...i found it be very good in terms of speed and compression.

Gethyn Ellis

gethynellis.com
Post #450356
Posted Friday, February 01, 2008 8:35 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:38 PM
Points: 318, Visits: 345
If all you're looking for are compressed backups with a little extra restore functionality take a look at HyperBac. They're a young startup, but they're not new to the backup game. I'll tell you how this fits into the picture.

HyperBac is a project of Jeffrey Aven. Jeffrey Aven was the original developer of LiteSpeed back when it was under DBAssociates. Then, Walter Scott bought DBAssociates and turned it into Imceda. He then turned around and sold Imceda to Quest for around 60mill. Walter left Quest shortly after and went to Acronis. Both Walter and Jeffrey have been under noncompete agreements and both their agreements are now expired. So Jeffrey started up HyperBac which is a SQL backup util, but it works more at the driver level. So you don't have to alter any of your code, and SQL doesn't have any idea of the existence of HyperBac. You just define where you want the backups to be compressed and it happens at the OS level when SQL takes a backup.

Now, Walter also has a new SQL backup util, but it's really not ready for any real SQL shops. It's ok, but everything has to be coded manually, and the interface isn't very stellar.

Now, as RedGate's product goes... I don't agree with the way they do everything, but I have worked with it and it's a nice tool. You can't really go wrong. Another bit of history here too. RedGate's tool used to be called MiniSQLBackup written by Peter Yeoh. At least I think I'm remembering that correctly. Anyway though, RedGate bought it and turned it into the product it is today. It's really nothing like it was when they bought it so they've definitely made it their own.

Yeoh still has products. You can see his stuff at http://www.yohz.com


Watch my free SQL Server Tutorials at:
http://MidnightDBA.ITBookworm.com

Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://www.infoworld.com/blogs/sean-mccown
DBA Rant – http://dbarant.blogspot.com
Post #450540
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse