Backups with SQL Server

Discussions specific to the Microsoft Hyper-V hypervisor

Backups with SQL Server

Veeam Logoby badams » Wed 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?
Posts: 29
Liked: never
Joined: Sun Jan 14, 2018 3:18 am
Full Name: Bert Adams

Re: Backups with SQL Server

Veeam Logoby vmniels » Thu 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)
Veeam Software
Posts: 1939
Liked: 423 times
Joined: Mon Jul 15, 2013 11:09 am
Full Name: Niels Engelen

Re: Backups with SQL Server

Veeam Logoby Mike Resseler » Mon 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: ... 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?

Mike Resseler
Veeam Software
Posts: 4523
Liked: 486 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Return to Microsoft Hyper-V

Who is online

Users browsing this forum: No registered users and 17 guests