Disable SQL Server Database Backup but backup VM

Availability for the Always-On Enterprise

Disable SQL Server Database Backup but backup VM

Veeam Logoby darkvision » Wed Sep 14, 2016 7:52 am

Hello guys,

I searched the forum but didn't find anything relating to my problem/request.

Among other backups we use Veeam to backup our VMs with SQL Server on it. These VMs running on Hyper-V. Now we want following scenario:

- A Veeam Backup Job with VMs with SQL Server on it
- Only save system drive of VM
- Do not touch the databases on the SQL Server

We created a job with following settings:
Image
Image
Image
Image
Image

The jobs works fine, the processed data matches the size of the system drive. The other drive holding the databases has over 3 TB and is ignored.

The problem now seems to be VSS. On the SQL Server I can see Veeam touching the databases. The weird think is Veeam touches the databases, but doesn't save any pages:
Image

Because of that the backup chain is broken !!

My guess is, that Veeam sees the SQL Server installed on the VM on the system drive and then wants to save the databases. Because these are saved on the skipped other drive, the databases will not be saved.
Then the SQL Server thinks they will be saved and updates the backup chain.

Does anyone has any idea how we can avoid this ?? Backing up the databases completely with Veeam is no option, because the snapshot of the disks holding the database files would be huge!

Thanks for any help!

Regards
darkvision
Novice
 
Posts: 5
Liked: never
Joined: Wed Sep 14, 2016 7:15 am

Re: Disable SQL Server Database Backup but backup VM

Veeam Logoby Vitaliy S. » Wed Sep 14, 2016 2:33 pm 1 person likes this post

Hi,

Since you've enabled native Hyper-V quiescence, it also triggers VSS writers of your SQL Server causing the behavior you have now. If you want to back up your databases with another approach, you need to enable AAIP option and select COPY_ONLY mode for this VM. Should do the trick.

Here is a similar topic for further reading > Veeam Backup and replication does not exclude SQL databases

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot] and 28 guests