Error message during SQL Server backup
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
October 24, 2008 4:32 PM
UPDATED:
October 25, 2008 12:08 AM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
