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

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?

vmniels
Veeam Software
Posts: 2002
Liked: 442 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Backups with SQL Server

Post by vmniels » 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.
VCP-DCV
Veeam Certified Architect (VMCA)
http://foonet.be

Mike Resseler
Veeam Software
Posts: 4825
Liked: 509 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

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?

Thanks
Mike

Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests