Error message during SQL Server backup

Tags:
SAN
SQL Server
SQL Server backup
SQL Server errors
We have a backup command that runs from within a command job on SQL Server A, and extracts data from SQL Servers B, C, D at different times to create a file on a SAN Drive. This is a daily job and runs successfully. Over the last fortnight, we have got the following error once for each different server: "SQLState = 08001, NativeError = 0 Error = [Microsoft][SQL Native Client]Unable to complete login process due to delay in opening server connection" What might this indicate is wrong?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Either you have some sort of network congestion or network latency, or the SQL Server is busy and can not process additional connection requests at that time. Check the CPU and memory counters of the server at the time of the error. You may have a query which is running out of control.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following