Solved

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?

Posted on 2014-09-24
3
132 Views
Last Modified: 2015-04-14
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
Comment
Question by:CityInfoSys
3 Comments
 
LVL 118
ID: 40341835
I would not recommend VDP Advanced over Veeam Backup and Replication.
0
 
LVL 10

Accepted Solution

by:
PadawanDBA earned 500 total points
ID: 40341917
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
 
LVL 1

Author Comment

by:CityInfoSys
ID: 40342138
Does Veeam Backup work with backing up MSSQL at the database or log file level?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
HOW TO: Install and Configure VMware vSphere Hypervisor 6.5 (ESXi 6.5), Step by Step Tutorial with screenshots. From Download, Checking Media, to Completed Installation.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now