Discussions specific to the Microsoft Hyper-V hypervisor
Post Reply
Posts: 29
Liked: never
Joined: Jan 14, 2018 3:18 am
Full Name: Bert Adams

Backups with SQL Server

Post by badams » Mar 14, 2018 7:52 pm

I was going through the user guide where it talks about creating a backup. I have always selected the VMs I wanted to backup, and it backed them up fine. And, I could restore them. But, now when I look closer, it shows "objects" I should include. Like SQL. Do I need to choose SQL Servers, etc. in order to make sure they are backed up? Is that part of Application Aware?

Veeam Software
Posts: 2971
Liked: 610 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen

Re: Backups with SQL Server

Post by nielsengelen » Mar 15, 2018 9:47 am

If you enable Application Aware processing for SQL you will be able to do database recovery & point in time restores. You can find more information on our Veeam Explorer for SQL via our userguide.
Veeam Certified Architect (VMCA)

Mike Resseler
Product Manager
Posts: 5891
Liked: 650 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium

Re: Backups with SQL Server

Post by Mike Resseler » Mar 19, 2018 8:09 am

Hi Bert,

Correct me if I misunderstood your question. What we mean by objects can be: Everything, Folder, Host Group, SCVMM, Cluster, Host or Virtual machine within Hyper-V. What you have been doing is perfect. No need to do something specific. What Niels above says is if you want to take advantage of application aware processing giving you item-level recovery for many workloads (SQL/ AD/ Exchange/ ...). Before you can do that, you need to tell the job that holds those servers that it needs to do application aware processing which is in this step: https://helpcenter.veeam.com/docs/backu ... tml?ver=95

But as said, selecting VMs is a perfect method, we just use objects as a name and not VMs because you can choose differently. And when that VM is a sql server, it will be protected no matter what, and with AAIP you will even have additional item-level restore options

Did I understand it correctly?


Post Reply

Who is online

Users browsing this forum: No registered users and 10 guests