Host-based backup of Microsoft Hyper-V VMs.
Post Reply
badams
Enthusiast
Posts: 30
Liked: never
Joined: Jan 14, 2018 3:18 am
Full Name: Bert Adams
Contact:

Backups with SQL Server

Post by badams »

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?
nielsengelen
Product Manager
Posts: 5635
Liked: 1181 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Backups with SQL Server

Post by nielsengelen »

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.
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
Mike Resseler
Product Manager
Posts: 8045
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Backups with SQL Server

Post by Mike Resseler »

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?

Thanks
Mike
Post Reply

Who is online

Users browsing this forum: No registered users and 20 guests