SQL 3rd Party Backup Agent vs SQL Backup

This is more of an Advise vs. how to technical question.  What are the advantages of using a SQL Backup Agent on SQL 2012 vs using Built in Backup?

  We have an IT person who is dead set against using any program to backup SQL and wants to do it directly with SQL Agent to a file share. For years, we have used BackupExec and has worked great. The problem is, this person controls the budget and I think wants to save money by this.

The SQL Server is pounded 24x7.  Any outage cost money and problems.  There are 2TB of SQL DB's being backed up.
LVL 4
egarrisonCEO / CTOAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David ToddSenior Database AdministratorCommented:
Hi,

Question:
If one database suffers some form of data corruption, how quickly could that be rectified - restore using Backup Exec, or SQL restore from a fileshare?

I suggest that the SQL Agent jobs will give better recovery in most scenarios, and in the dead machine category won't be significantly longer to restore.

I recommend using Ola Hallengren's script to perform the backups.

HTH
  David

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
egarrisonCEO / CTOAuthor Commented:
Our backup Exec is on a high speed network and disk based backup solution.  Restores are pretty fast and because they are stored on a separate machine, the speeds are pretty much the same as pull from Fileshare.

 I found the Ola script, it looks pretty good.

We don't seem to have the dashboard and alerting that we get with BackupExec.
David ToddSenior Database AdministratorCommented:
Hi,

Alerting -
Set up database mail
set up SQL Agent to use a database mail profile
set up operator(s) in SQL Agent
set up alerts in SQL Agent for errors
set up alerts in SQL Agent for ALL enabled & scheduled jobs

You now have alerting from SQL Server.

dashboard -
pretty much everything that Ola's script actually does is logged in dbo.CommandLog

HTH
  David
Vitor MontalvãoMSSQL Senior EngineerCommented:
I think the main reason to have a 3rd party backup software is to centralize all backups in one solution and have a single team to take care about it. This will also free the DBA's to do other important tasks.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.