Hyper-V and SQL Server Backup

Hyper-V specific discussions

Hyper-V and SQL Server Backup

Veeam Logoby Bygmait » Tue Feb 19, 2013 7:00 am

Hi

I'm trying to setup an backup solutions for my SQL Server 2008, running in a Hyper-V mode.
There are two SQL Servers that I need to backup.

On each SQL Server, theres a local backup jobs running backup of the entire database and log files to an local backup storage, lying on a NAS unit, connected though iSCSI to the SQL Server.
So my Veeam B&R dosn't need to backup the database, logfiles and so on, but only the virtual machine it self, and configuration.

I therefore tryed to make an exclusion on the backup to only take the systemdrive disk, but it looks like it dosn't matter.
The size of the backup is still equal the size of the entire SQL server incl. all drives.

Is this the right way to backup an SQL Server? To exclude the disk drives that contains the database files, log files and backup files?
And how is this done the right way?

Thanks.
Bygmait
Novice
 
Posts: 7
Liked: never
Joined: Mon Jul 11, 2011 1:13 pm
Full Name: BygmaIT

Re: Hyper-V and SQL Server Backup

Veeam Logoby v.Eremin » Tue Feb 19, 2013 10:50 am

Just for the purpose of complete understanding – are you talking about recalculate tab or you’d actually backed up your SQL server with unnecessary disk being included/excluded and saw no difference in backup sizes?

Can you also confirm that specified disks were excluded from processing? In the job statistics window should be something like this: “Excluding disk Name of your VM”.

Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Hyper-V and SQL Server Backup

Veeam Logoby Bygmait » Tue Feb 19, 2013 1:49 pm

Hi

I'm not getting an info about excluded disk in the statistic picture.

http://peecee.dk/upload/view/402147/SQL_Picture.png

The disc with the arrow, is the one that I want to back up, and all the others are disc to databases, logfiles and backup, that I don't need to include in my backup.
Bygmait
Novice
 
Posts: 7
Liked: never
Joined: Mon Jul 11, 2011 1:13 pm
Full Name: BygmaIT

Re: Hyper-V and SQL Server Backup

Veeam Logoby foggy » Tue Feb 19, 2013 2:26 pm

Have you excluded disks at the Virtual Machines step of the job settings wizard? Can you provide the screen of the Exclusions dialog, please?
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Hyper-V and SQL Server Backup

Veeam Logoby Vitaliy S. » Tue Feb 19, 2013 9:20 pm

Bygmait wrote:Is this the right way to backup an SQL Server? To exclude the disk drives that contains the database files, log files and backup files?
And how is this done the right way?

Another way to backup your SQL Server would be just to backup the entire VM image with "application aware image processing option" enabled, pretty common practice among our customers.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 9 guests