MSSqlServer 2012 Backup solution/Best MSSQL drive type VMware Physical/Virtual located on a SAN or VMDK located in a datastore on the SAN for the data and log drives?

We are currently looking for a good MSSQL Server 2012 backup solution. Has anyone tried VMware VDP Advanced for backing up databases? What would you recommend and why?

VMWare Windows 2012 R2 with MSSQL 2012
LVL 2
CityInfoSysAsked:
Who is Participating?
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.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
I would not recommend VDP Advanced over Veeam Backup and Replication.
0
PadawanDBAOperational DBACommented:
Any reason you don't want to use native backups?  They have native compression (usually at 1/5-1/7th the size of uncompressed backups).  As of SQL Server 2014, native backups can also be encrypted.  You have your standard players for 3rd party SQL Server backups, however:


Quest Litespeed - http://software.dell.com/products/litespeed-for-sql-server/

Idera Safe Backup - https://www.idera.com/productssolutions/sqlserver/sqlsafebackup

RedGate SQL Backup Pro - http://www.red-gate.com/products/dba/sql-backup/

They all get the job done, but have different UI's and features.  They also all have free trials.  I wholeheartedly recommend downloading the trials and giving them all a try and deciding which one works best for you.
0

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
CityInfoSysAuthor Commented:
Does Veeam Backup work with backing up MSSQL at the database or log file level?
0
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
VMware

From novice to tech pro — start learning today.