Can't get SureBackup SQL test to not fail

VMware specific discussions

Can't get SureBackup SQL test to not fail

Veeam Logoby pufferdude » Mon Feb 02, 2015 10:43 pm

I have what should be a pretty simple setup: Two SQL/web servers in a surebackup job (one 2008 R2, the other 2012 R2) that rely on a single 2012 DC in the Application Group. The DC starts up just fine and passes all its tests. The other two hosts start up fine and pass the web server test but neither passes the SQL test. I'm not sure where to even start looking. Is there a "trick" to getting the surebackup job configured to accurately test a SQL server? I'm not even sure how to manually fire up the surebackup job so I can look inside the VMs to see what's happening. That said, IF I manually "instant restore" one of these VMs from backup, I can see that SQL server is running just fine... so this seems to be a "false negative" with the surebackup test... I must have something configured wrong.

Any advice on configuring or troubleshooting this thing?
pufferdude
Expert
 
Posts: 131
Liked: 5 times
Joined: Thu Jul 02, 2009 8:26 pm
Full Name: Jim

Re: Can't get SureBackup SQL test to not fail

Veeam Logoby v.Eremin » Tue Feb 03, 2015 10:11 am

Can you write an error that SureBackup Job throws? Thanks.
v.Eremin
Veeam Software
 
Posts: 13734
Liked: 1027 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Can't get SuerBackup SQL test to not fail

Veeam Logoby foggy » Tue Feb 03, 2015 10:48 am 1 person likes this post

Jim, are you on v8? Starting v8, SQL test script does not simply ping the corresponding ports on the server, but instead checks connection to every instance, so requires appropriate rights to perform this (minimum rights are required, need to check the exact role). You can either give the service account rights on the SQL server or pass the credentials as script arguments in SureBackup job (check Veeam.Backup.SqlChecker.vbs in the product installation folder for details).

If you need assistance with this, feel free to contact technical support.
foggy
Veeam Software
 
Posts: 15303
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Can't get SureBackup SQL test to not fail

Veeam Logoby pufferdude » Tue Feb 03, 2015 3:42 pm

Foggy... thanks, I think this might be my issue. Currently the job is using the predefined SQL Server script. I don't see a way to edit the arguments when "Use Predefined test script" is chosen, so I guess I need to choose "Use the following test script" and then navigate to the SQL server script and fill out everything manually? But if that's the case and this script *cannot* work without credentials being passed via arguments, that makes me wonder why the option to use the predefined SQL Server script exists at all, since it would never be able to work.

I'm probably still missing something, but at least I can try to configure the SQL Server script manually and see what happens.
pufferdude
Expert
 
Posts: 131
Liked: 5 times
Joined: Thu Jul 02, 2009 8:26 pm
Full Name: Jim

Re: Can't get SureBackup SQL test to not fail

Veeam Logoby foggy » Tue Feb 03, 2015 3:59 pm

Well, it may work, if the service account has corresponding permissions. However, I agree this is not intuitive and we are going to add the ability to supply credentials via UI further down the road.
foggy
Veeam Software
 
Posts: 15303
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

[MERGED] Surebackup - sql verification failed

Veeam Logoby frankive » Fri May 15, 2015 7:32 am

I have a surebackup I am testing out for a sql-server. If I enable sql script for verifying it fails with error code 2.
At the same time, I can fine telnet port 1433 from the veeam server against the masqerda ip of the sql-server.
What does the script relaly check? Is it not just a plain telnet check?
frankive
Service Provider
 
Posts: 738
Liked: 86 times
Joined: Tue May 14, 2013 8:35 pm
Location: Norway
Full Name: Frank Iversen

Re: Surebackup - sql verification failed

Veeam Logoby marc.rousseau » Fri May 15, 2015 11:16 am

vmware-vsphere-f24/can-t-get-suerbackup-sql-test-to-not-fail-t26053.html
"Starting v8, SQL test script does not simply ping the corresponding ports on the server, but instead checks connection to every instance, so requires appropriate rights to perform this (minimum rights are required, need to check the exact role)."
marc.rousseau
Enthusiast
 
Posts: 25
Liked: 11 times
Joined: Thu May 01, 2014 9:48 am
Full Name: marc.rousseau

Re: Can't get SureBackup SQL test to not fail

Veeam Logoby frankive » Fri May 15, 2015 12:53 pm

+1
This is a "must have" for us as a service provider
frankive
Service Provider
 
Posts: 738
Liked: 86 times
Joined: Tue May 14, 2013 8:35 pm
Location: Norway
Full Name: Frank Iversen

Re: Surebackup - sql verification failed

Veeam Logoby frankive » Fri May 15, 2015 1:52 pm

Ah, thanks!
A very nice post blog here as well:
http://www.danilochiavari.com/2014/12/0 ... eam-br-v8/
frankive
Service Provider
 
Posts: 738
Liked: 86 times
Joined: Tue May 14, 2013 8:35 pm
Location: Norway
Full Name: Frank Iversen

Re: Can't get SureBackup SQL test to not fail

Veeam Logoby lennis40 » Thu Jun 25, 2015 5:16 pm

Where at in the SQLChecker.vbs script do you modify the username and password to use during the SureBackup job. I've had a support case open for serveral days, and everything I've been told to try hasn't worked. Still getting error code 2. I don't know why credentials aren't allowed to be entered when setting up the SureBackup job, seems like an oversight.

Support Case 00941222
lennis40
Service Provider
 
Posts: 122
Liked: 3 times
Joined: Tue Nov 11, 2014 11:03 pm
Full Name: Michael

Re: Can't get SureBackup SQL test to not fail

Veeam Logoby frankive » Thu Jun 25, 2015 7:31 pm 1 person likes this post

I pass the username and password as an argument in the application group and under Test Scripts.
Take at look half way down this blog: http://www.danilochiavari.com/2014/12/0 ... eam-br-v8/
frankive
Service Provider
 
Posts: 738
Liked: 86 times
Joined: Tue May 14, 2013 8:35 pm
Location: Norway
Full Name: Frank Iversen

Re: Can't get SureBackup SQL test to not fail

Veeam Logoby lennis40 » Fri Jun 26, 2015 2:20 pm

frankive wrote:I pass the username and password as an argument in the application group and under Test Scripts.
Take at look half way down this blog: http://www.danilochiavari.com/2014/12/0 ... eam-br-v8/



I've looked at that post, but do I just need username/password in the arguments section, or do I actually have to modify the script I am pointing to as well? That's what I don't understand. If it's just adding the username and password to the arguments section, that seems easy enough. Thanks.
lennis40
Service Provider
 
Posts: 122
Liked: 3 times
Joined: Tue Nov 11, 2014 11:03 pm
Full Name: Michael

Re: Can't get SureBackup SQL test to not fail

Veeam Logoby frankive » Fri Jun 26, 2015 11:17 pm

you add username and password into the arguments, not the script itself. I never touch the script when I setup this.

I create a user named f.ex "surebackup" and with a password in the sql server you want to backup (and test). Just give it the lowest privilegie (public) like he says in the blog.it it that account you connect to when you pass the arguments.
frankive
Service Provider
 
Posts: 738
Liked: 86 times
Joined: Tue May 14, 2013 8:35 pm
Location: Norway
Full Name: Frank Iversen

Re: Can't get SureBackup SQL test to not fail

Veeam Logoby lennis40 » Sun Jun 28, 2015 2:22 am

Thanks. I'll give it a shot.
lennis40
Service Provider
 
Posts: 122
Liked: 3 times
Joined: Tue Nov 11, 2014 11:03 pm
Full Name: Michael

Re: Can't get SureBackup SQL test to not fail

Veeam Logoby lennis40 » Mon Jun 29, 2015 6:59 pm

I have passed credentials via argument, but the SureBackup job is still failing on the SQL script. When I run the script from the command line, using the credentials created with Public permissions, it runs successfully on each SQL server I test. Working with support this afternoon. I have upped the application timeout to 900, as recommended by support, but still not having any luck.
lennis40
Service Provider
 
Posts: 122
Liked: 3 times
Joined: Tue Nov 11, 2014 11:03 pm
Full Name: Michael

Next

Return to VMware vSphere



Who is online

Users browsing this forum: Google [Bot] and 1 guest