Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • Last Modified:

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
0
CityInfoSys
Asked:
CityInfoSys
1 Solution
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
I would not recommend VDP Advanced over Veeam Backup and Replication.
0
 
PadawanDBACommented:
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
 
CityInfoSysAuthor Commented:
Does Veeam Backup work with backing up MSSQL at the database or log file level?
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now