I have been using Ola Hallengreen maintenance plan . It has been working great for longtime . Recently one of my nightly backup job failed repeatedly with an error:
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Unable to complete login process due to delay in opening server connection
I then execute the job manually by right clicking on it and start at step... and it runs fine. No problem.
The server is SQL Server 2008R2.
Does any one know why the job failed?