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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!