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?