SQL Server 2005 Backup Third Party Tools

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » SQL Server 2005 Backup Third Party Tools

30 posts, Page 1 of 3

1 2 3 »»»

SQL Server 2005 Backup Third Party Tools

Rate Topic

Display Mode

Topic Options

Author

Message

charlesd

Posted Tuesday, January 29, 2008 2:43 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, June 14, 2013 1:37 PM
Points: 38, Visits: 387

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

free_mascot

Posted Wednesday, January 30, 2008 6:18 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 7:23 AM
Points: 1,771, Visits: 1,316

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

KenpoDBA

Posted Wednesday, January 30, 2008 7:58 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 9:40 PM
Points: 314, Visits: 295

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

alen teplitsky

Posted Thursday, January 31, 2008 8:32 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, June 10, 2013 10:43 AM
Points: 1,411, Visits: 4,517

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

Chris Benvenuto

Posted Thursday, January 31, 2008 9:01 AM

Grasshopper

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

Phillip Cox

Posted Thursday, January 31, 2008 9:01 AM

SSCrazy

Group: General Forum Members
Last Login: Friday, October 12, 2012 7:55 AM
Points: 2,133, Visits: 604

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

Chris Benvenuto

Posted Thursday, January 31, 2008 9:04 AM

Grasshopper

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

Ray Mond

Posted Thursday, January 31, 2008 9:46 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 7:06 PM
Points: 343, Visits: 1,514

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

GRE (Gethyn Ellis)

Posted Friday, February 01, 2008 1:35 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 9:55 AM
Points: 1,024, Visits: 2,768

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

KenpoDBA

Posted Friday, February 01, 2008 8:35 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 9:40 PM
Points: 314, Visits: 295

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 »

30 posts, Page 1 of 3

1 2 3 »»»

Permissions