Comprehensive data protection for all workloads
Post Reply
mschlott
Enthusiast
Posts: 84
Liked: 2 times
Joined: Jan 20, 2011 5:45 pm
Full Name: Mike Schlottman
Contact:

Surebackup SQL verification failing

Post by mschlott » Aug 01, 2011 5:12 pm

I have a SQL server that is running in a sure backup job. If I turn off SQL verification, and leave the job runing, I can verify that the SQL server is running and I can connect to it from my Veeam server. If SQL verification is turned on, the test fails.

Support tells me that the SQL verification test is just a ping of port 1433. The server is running a named instance of SQL and I have found, that any of our SQL server that run named instances, do not listen on port 1433. Is there something that I can do to have Veeam acurately test wether a SQL server is actually running instead of a ping of port 1433. If this is a SQL configuration issue, I'd like to know that too. I am not a SQL admin. I only play one, when things are broke.

mike

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

Re: Surebackup SQL verification failing

Post by Gostev » Aug 01, 2011 9:39 pm

Hi Mike, actually it does not ping (ping is a separate test), but verifies if the port is listening (like telnet). The port is customizable by editing the predefined script in the product installation folder (if you can figure out the port that your SQL servers are listening), or of course you can always make your own test script instead (for example, script that check SQL Server process state, or something more complex). Thanks.

Post Reply

Who is online

Users browsing this forum: obijay and 28 guests