Discussions specific to the Microsoft Hyper-V hypervisor
Post Reply
pcts
Service Provider
Posts: 6
Liked: 3 times
Joined: Nov 15, 2017 6:16 pm
Contact:

Hyper V - SQL VM Backup Guidance Needed

Post by pcts » Nov 16, 2017 12:35 pm

Hi there, we have a two node hyper v cluster (Windows Server 2012 R2). Two Hyper V servers have their OS on local drives. Our setup has 5 VM's, 3 of which are on shared storage (SAN) and the other two are domain controllers one local to each host.

I am currently trialing Veeam B&R to backup the VM's from the shared storage to another server repository.

We have 2 x SQL Server VMs in the cluster and have SQL undertaking separate daily and hourly SQL backups (transactional) for them and we are thinking that we might be best to retain SQL ownership for these, so should we disable "application aware processing" when using Veeam to backup the SQL VM and should we also exclude certain volumes (logs, data, backup etc) from the SQL VM backup using Veeam?

Thanks
PCTS

foggy
Veeam Software
Posts: 18037
Liked: 1533 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Hyper V - SQL VM Backup Guidance Needed

Post by foggy » Nov 16, 2017 3:28 pm

You can leave application-aware image processing on but configure it to perform copy only backup.

nmdange
Expert
Posts: 457
Liked: 107 times
Joined: Aug 20, 2015 9:30 pm
Contact:

Re: Hyper V - SQL VM Backup Guidance Needed

Post by nmdange » Nov 16, 2017 5:11 pm

It would be beneficial to have Veeam perform the hourly transaction log backups instead of SQL Server. Using Veeam to do it will allow you to keep those transaction log backups on your backup repository. So if you lose your entire SAN, you can still restore your SQL databases to the most recent transaction log backup, rather than having to go back to the last full VM backup. I also find it easier and quicker to have Veeam restore the logs for you, rather than having to manually run a RESTORE DATABASE command on a bunch of separate transaction log backup files.

pcts
Service Provider
Posts: 6
Liked: 3 times
Joined: Nov 15, 2017 6:16 pm
Contact:

Re: Hyper V - SQL VM Backup Guidance Needed

Post by pcts » Nov 23, 2017 9:35 am 1 person likes this post

@foggy - thanks for this - I tried this and it worked successfully.

@nmdange - thank you also for your insight and recommendations. I will have to get up to speed on how to configure the SQL server transaction log backup and restore process using Veeam but this sounds like a more comprehensive approach given it protects also again the loss of the SAN.

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 8 guests