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
145 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 121
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

628 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