SQL Guest processing failures when auto-including VMs

Discussions specific to Microsoft Hyper-V hypervisor

SQL Guest processing failures when auto-including VMs

Veeam Logoby zaf » Mon Mar 21, 2016 5:23 pm 1 person likes this post

Hi,
I've been fighting an issue for several days with guest processing (SQL backups) and while I have finally made some headway, I want to share what I've learned because I feel like this is a bug.

How I created the job initially:
We are using SCVMM and guests live on several CSVs (about 14 CSVs). I created a backup job per CSV and added JUST the CSV to the backup job, not guests. I did however add Exclusions for guests that I do not want to back up. Under Guest Processing, I added individual guests that I want to process by clicking Add, browsing the CSV, and selecting those VMs. The default Object was set to VSS processing Disabled, but for each of the VMs that were added, I set SQL backup options. Credentials were added on the job in a similar fashion (this is a multi-tenant setup, so each VM could have its own set of credentials).
Results:
The subsequent 'SQL Server Transaction Log Backup' jobs using this method always fail with the warnings: "Failed to prepare guest for SQL Server transaction log backup Details: No accessible proxies" I have troubleshot network connectivity, permissions, etc, and had no issues that I could find.

Workaround:
I re-created the jobs by manually specifying guest VMs rather than specifying the CSV. Everything else was set the same, except now, the jobs don't enumerate the VMs when they run, since they are all explicitly added. Using this method, the SQL backup processes actually complete perfectly as expected (so far). The downside is that now the dynamic nature of my jobs is gone, forcing us to go through a manual process of adding/removing VMs.

I have opened ticket 01726633 on this as well, and it contains some of my logs.
zaf
Service Provider
 
Posts: 7
Liked: 1 time
Joined: Mon Jan 11, 2016 7:08 pm
Full Name: Tim Fournet

Re: SQL Guest processing failures when auto-including VMs

Veeam Logoby v.Eremin » Mon Mar 21, 2016 6:06 pm

Looks like an unexpected behaviour to me. Kindly, keep working with our support team on addressing that. Thanks.
v.Eremin
Veeam Software
 
Posts: 14725
Liked: 1103 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: SQL Guest processing failures when auto-including VMs

Veeam Logoby matsholm » Tue Jan 24, 2017 7:26 am

Hi zaf
Did you get any solutuion to this?
I have the same situation where some SQL servers warn with "Failed to prepare guest for SQL Server transaction log backup Details: No accessible proxies" with auti-include using VM folders.
When adding manually it works

//Mats
matsholm
Influencer
 
Posts: 19
Liked: 1 time
Joined: Tue Jan 19, 2016 8:02 am
Full Name: Mats Holm

Re: SQL Guest processing failures when auto-including VMs

Veeam Logoby atong888999 » Thu Mar 22, 2018 7:01 am

I also have the same problem, could you told me how to add manually ?
atong888999
Novice
 
Posts: 3
Liked: never
Joined: Mon Jan 04, 2016 2:21 am
Full Name: Mington

Re: SQL Guest processing failures when auto-including VMs

Veeam Logoby Mike Resseler » Thu Mar 22, 2018 7:29 am

Hi Mington,

Unfortunately we have no additional information from the OP so I can't check what the solution was. Did you checked this KB: https://www.veeam.com/kb2029 to see if it implies to you?
Look also if the VM wasn't protected by another job before the auto-inclusion.

If that is not the case, please also create a support call (post the case ID here and the follow-up/result after the research of our engineers)

Thanks
Mike
Mike Resseler
Veeam Software
 
Posts: 4230
Liked: 471 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: v.Eremin and 12 guests