Comprehensive data protection for all workloads
Post Reply
darkvision
Novice
Posts: 5
Liked: never
Joined: Sep 14, 2016 7:15 am
Contact:

Disable SQL Server Database Backup but backup VM

Post by darkvision » 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

Vitaliy S.
Product Manager
Posts: 22773
Liked: 1526 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Disable SQL Server Database Backup but backup VM

Post by Vitaliy S. » 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!

Post Reply

Who is online

Users browsing this forum: Baidu [Spider], Bing [Bot], Google [Bot] and 25 guests