Host-based backup of Microsoft Hyper-V VMs.
Post Reply
zaf
Service Provider
Posts: 7
Liked: 1 time
Joined: Jan 11, 2016 7:08 pm
Full Name: Tim Fournet
Contact:

SQL Guest processing failures when auto-including VMs

Post by zaf » 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.
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Guest processing failures when auto-including VMs

Post by veremin »

Looks like an unexpected behaviour to me. Kindly, keep working with our support team on addressing that. Thanks.
matsholm
Influencer
Posts: 19
Liked: 1 time
Joined: Jan 19, 2016 8:02 am
Full Name: Mats Holm
Contact:

Re: SQL Guest processing failures when auto-including VMs

Post by matsholm »

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
atong888999
Novice
Posts: 4
Liked: never
Joined: Jan 04, 2016 2:21 am
Full Name: Mington
Contact:

Re: SQL Guest processing failures when auto-including VMs

Post by atong888999 »

I also have the same problem, could you told me how to add manually ?
Mike Resseler
Product Manager
Posts: 8044
Liked: 1263 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: SQL Guest processing failures when auto-including VMs

Post by Mike Resseler »

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
Post Reply

Who is online

Users browsing this forum: No registered users and 21 guests