Comprehensive data protection for all workloads
Post Reply
Cragdoo
Veeam Vanguard
Posts: 522
Liked: 207 times
Joined: Sep 27, 2011 12:17 pm
Full Name: Craig Dalrymple
Location: Scotland
Contact:

Surebackup - SQL tests failing

Post by Cragdoo » Jan 25, 2016 1:04 pm

SInce upgrading to v9 , my Surebackup job keeps failing on my SQL VM when running the SQL port tests

Code: Select all

SQL_Port, failed - The system cannot find the file specified
Error    Predefined script 2: name Sql Server, error code 2
Is this a known issue ?

If not, I'll raise a support ticket.

Gostev
SVP, Product Management
Posts: 24300
Liked: 3331 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Surebackup - SQL tests failing

Post by Gostev » Jan 25, 2016 1:11 pm

Anything that does not come up in the forum search is not a known issue :D

foggy
Veeam Software
Posts: 17931
Liked: 1512 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Surebackup - SQL tests failing

Post by foggy » Jan 25, 2016 2:30 pm

Craig, have you checked whether the testing script is actually there?

Cragdoo
Veeam Vanguard
Posts: 522
Liked: 207 times
Joined: Sep 27, 2011 12:17 pm
Full Name: Craig Dalrymple
Location: Scotland
Contact:

Re: Surebackup - SQL tests failing

Post by Cragdoo » Jan 25, 2016 4:26 pm

yeah, the script is there on the VBR server.

I'll do some digging around in the logs, then raise a call with support

nefes
Veeam Software
Posts: 623
Liked: 155 times
Joined: Dec 10, 2012 8:44 am
Full Name: Nikita Efes
Contact:

Re: Surebackup - SQL tests failing

Post by nefes » Jan 25, 2016 4:38 pm

I suppose, it is credentials problem.
Please set correct account at Credentials tab for your SQL VM.

Cragdoo
Veeam Vanguard
Posts: 522
Liked: 207 times
Joined: Sep 27, 2011 12:17 pm
Full Name: Craig Dalrymple
Location: Scotland
Contact:

Re: Surebackup - SQL tests failing

Post by Cragdoo » Jan 25, 2016 5:07 pm

would incorrect credentials cause a script to crash ??
SQL_Port script, Path: D:\Program Files\Veeam\Backup\Veeam.Backup.ConnectionTester.exe, Args: 192.168.255.58 1433, Result: Crashed

nefes
Veeam Software
Posts: 623
Liked: 155 times
Joined: Dec 10, 2012 8:44 am
Full Name: Nikita Efes
Contact:

Re: Surebackup - SQL tests failing

Post by nefes » Jan 25, 2016 5:13 pm

No, it should not. Seems that my guess was not right.
It is worth involving support in your case, since crashes cannot be effectively troubleshooted via forums.

Cragdoo
Veeam Vanguard
Posts: 522
Liked: 207 times
Joined: Sep 27, 2011 12:17 pm
Full Name: Craig Dalrymple
Location: Scotland
Contact:

Re: Surebackup - SQL tests failing

Post by Cragdoo » Jan 25, 2016 5:17 pm

Done, Support Case #01677150

JaxIsland7575
Veeam Vanguard
Posts: 385
Liked: 104 times
Joined: Apr 27, 2015 1:59 pm
Full Name: Ryan Jacksland
Location: NY, USA
Contact:

Re: Surebackup - SQL tests failing

Post by JaxIsland7575 » Jan 25, 2016 5:39 pm

Craig,
Have you started the SureBackup job then logged into the SQL server and ran the scripts manually from SQL Management? I had a permissions issue and that helped me find it.

Cheers!
VMCE v9

fja
Influencer
Posts: 21
Liked: 1 time
Joined: May 26, 2015 8:58 am
Contact:

Re: Surebackup - SQL tests failing

Post by fja » Nov 21, 2016 2:37 pm

Was this resolved by support? Having same issue on v.9... Seems to be intermittent. Suspect this could be due to SQL-log file backup running during surebackup job duration...

foggy
Veeam Software
Posts: 17931
Liked: 1512 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Surebackup - SQL tests failing

Post by foggy » Nov 21, 2016 2:42 pm

In the OP's case the issue was caused by the wrong path to the Veeam installation folder containing the script. So looks like you have a different one, I recommend contacting support for a closer look.

Post Reply

Who is online

Users browsing this forum: No registered users and 11 guests