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
135 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 119
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Viewers will learn how the fundamental information of how to create a table.
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

810 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