Sometimes you may get an error log when your backup maintenance plan job gets fails with the following error on a server with many databases or connections:
Message:
Executed as user: xyz\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 01:00:05 AM Could not load package "Maintenance Plans\xyz" because of error 0xC0014062.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0-80004005 (Unable to complete login process due to delay in opening server connection). The SQL statement that was issued has failed.
Source: Started: 01:00:05 AM Finished: 01:01:02 AM Elapsed: 57.175 seconds.
The package could not be loaded. The step failed.
This indicates that the maintenance plan which uses SSIS (integrated services) and msdb databases is delay in connection. To resolve this issue general recommendation could be
Change the host file
Which is generally located at “C:\WINDOWS\system32\drivers\etc\host” add server name and an IP address.
Change the number of retry for the specific job to greater number (eg. 5 or more) and also can change the retry interval to (0). This way if this job fails with delay in connection, will retry again till specified number of times and mostly it gets succeeded.
Message:
Executed as user: xyz\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.5500.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 01:00:05 AM Could not load package "Maintenance Plans\xyz" because of error 0xC0014062.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0-80004005 (Unable to complete login process due to delay in opening server connection). The SQL statement that was issued has failed.
Source: Started: 01:00:05 AM Finished: 01:01:02 AM Elapsed: 57.175 seconds.
The package could not be loaded. The step failed.
This indicates that the maintenance plan which uses SSIS (integrated services) and msdb databases is delay in connection. To resolve this issue general recommendation could be
Change the host file
Which is generally located at “C:\WINDOWS\system32\drivers\etc\host” add server name and an IP address.
Change the number of retry for the specific job to greater number (eg. 5 or more) and also can change the retry interval to (0). This way if this job fails with delay in connection, will retry again till specified number of times and mostly it gets succeeded.
No comments:
Post a Comment