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

Surebackup - SQL tests failing

Post by Cragdoo »

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
Chief Product Officer
Posts: 31807
Liked: 7300 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Surebackup - SQL tests failing

Post by Gostev »

Anything that does not come up in the forum search is not a known issue :D
foggy
Veeam Software
Posts: 21139
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Surebackup - SQL tests failing

Post by foggy »

Craig, have you checked whether the testing script is actually there?
Cragdoo
Veeam Vanguard
Posts: 629
Liked: 251 times
Joined: Sep 27, 2011 12:17 pm
Full Name: Craig Dalrymple
Location: Scotland
Contact:

Re: Surebackup - SQL tests failing

Post by Cragdoo »

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: 649
Liked: 170 times
Joined: Dec 10, 2012 8:44 am
Full Name: Nikita Efes
Contact:

Re: Surebackup - SQL tests failing

Post by nefes »

I suppose, it is credentials problem.
Please set correct account at Credentials tab for your SQL VM.
Cragdoo
Veeam Vanguard
Posts: 629
Liked: 251 times
Joined: Sep 27, 2011 12:17 pm
Full Name: Craig Dalrymple
Location: Scotland
Contact:

Re: Surebackup - SQL tests failing

Post by Cragdoo »

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: 649
Liked: 170 times
Joined: Dec 10, 2012 8:44 am
Full Name: Nikita Efes
Contact:

Re: Surebackup - SQL tests failing

Post by nefes »

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: 629
Liked: 251 times
Joined: Sep 27, 2011 12:17 pm
Full Name: Craig Dalrymple
Location: Scotland
Contact:

Re: Surebackup - SQL tests failing

Post by Cragdoo »

Done, Support Case #01677150
JaxIsland7575
Veteran
Posts: 391
Liked: 107 times
Joined: Apr 27, 2015 1:59 pm
Full Name: Ryan Jacksland
Location: NY, USA
Contact:

Re: Surebackup - SQL tests failing

Post by JaxIsland7575 »

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
Enthusiast
Posts: 28
Liked: 1 time
Joined: May 26, 2015 8:58 am
Contact:

Re: Surebackup - SQL tests failing

Post by fja »

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: 21139
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Surebackup - SQL tests failing

Post by foggy »

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: Bing [Bot], cserban, Dima P., Majestic-12 [Bot], Semrush [Bot] and 294 guests