Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 What backup software do you use for large backups?

Author  Topic 

DBADave
Constraint Violating Yak Guru

366 Posts

Posted - 2008-12-16 : 11:06:50
We use ArcServe to backup database .bak files to tape nightly. This product has worked well, but we have concerns that it will not be able to perform fast enough for large database backups such as 500+ GB. Which leads to my questions.

What backup software do you use for backing up large .bak files to tape and how fast does it perform?

Do you use Microsoft SQL Server's built-in backup solution for backing up large databases to disk or do you use a third-party product?

Thanks, Dave

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-16 : 11:32:25
We use Quest's Litespeed product for all of our databases (hundreds of them). We are now considering Red Gate's backup solution due to cost. Due to the number of servers that we support, cost is a huge factor. Red Gate's solution is practically identical to Quest's solution as far as features go, performance, etc. But Red Gate's is much, much cheaper.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

DBADave
Constraint Violating Yak Guru

366 Posts

Posted - 2008-12-16 : 13:12:46
Thanks Tara. What tape backup software do you use for your large backups?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-16 : 13:13:53
We use Netbackup for all of our tape backups. We don't have any different solution for small databases or large ones. We use Netbackup as an Enterprise solution, meaning all files needing to be backed up to tape go through that and not just SQL files.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -