Always-On-Group Support for MSSQL for "SQL DB Exclusions"

VMware specific discussions

Always-On-Group Support for MSSQL for "SQL DB Exclusions"

Veeam Logoby Patschi » Tue Sep 22, 2015 7:59 am 1 person likes this post

Basically Veeam works very well when backuping up MSSQL 2014 nodes, but when you're having the vCenter database also running on the same AOG, I ran into the problem that Veeam wasn't able to backup the machines because of the VSS error “VSSControl: Failed to freeze guest, wait timeout”:
Image

Ofcourse the database was added to the "SQL Databases Exclusions"-list, but this did change nothing - it just keeps failing and failing: (Veeam detected the DB data itself fully automatically)
Image

After investigating the problem further, I finally found out (more detailed in german language on my site http://pkern.at/veeam-vsscontrol-failed ... it-timeout), that Veeam seems not to be able to understand, that there is a AOG behind the DNS name in the exclusions list. So when I manually add the nodes behind that Always-On-Group manually to the list, like that:
Image

After that the backups works fine again! :)

I don't know if this is just an issue on my side, an already known issue, or any sort of a bug, but I wanted to share it in the Veeam forum anyway. Maybe someone runs also into a similiar issue someday...

Best regards,
Patrik Kernstock
Patschi
Influencer
 
Posts: 12
Liked: 3 times
Joined: Sat Jan 17, 2015 7:16 pm
Location: Austria, Lower Austria
Full Name: Patrik Kernstock

Re: Always-On-Group Support for MSSQL for "SQL DB Exclusions

Veeam Logoby foggy » Tue Sep 22, 2015 10:57 am 1 person likes this post

Patrik, thanks for paying our attention to this. You've applied a valid workaround, however databases detection/exclusion mechanism should be improved to address this scenario, so this will be tracked as a requirement for future versions. Thanks.
foggy
Veeam Software
 
Posts: 14728
Liked: 1077 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Always-On-Group Support for MSSQL for "SQL DB Exclusions

Veeam Logoby Patschi » Tue Sep 22, 2015 6:22 pm

My pleasure! I just realized it after creating the topic: Maybe this thread would better fit in the sub-forum for VMware vSphere, because this issue is just related to the VMware vCenter anyway.
Patschi
Influencer
 
Posts: 12
Liked: 3 times
Joined: Sat Jan 17, 2015 7:16 pm
Location: Austria, Lower Austria
Full Name: Patrik Kernstock

Re: Always-On-Group Support for MSSQL for "SQL DB Exclusions

Veeam Logoby foggy » Wed Sep 23, 2015 9:30 am 1 person likes this post

No problem, I've moved the thread. Thanks again for the heads up.
foggy
Veeam Software
 
Posts: 14728
Liked: 1077 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to VMware vSphere



Who is online

Users browsing this forum: Majestic-12 [Bot] and 20 guests