July 21, 2006 at 2:56 am
All,
Advice required. Recently we are having recurring DTS package failure due to a timeout issue this seems to run hand in hand with a dramatic increase in a backup job run time from approx. 9 mins to over an hour.
Within the error logs am receiving log entries as below:
2006-07-18 14:00:39 - ! [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]
2006-07-18 14:00:39 - ! [382] Logon to server '(local)' failed (JobManager)
Recorded for jobs on the local server
AND
[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]
Run from a remote server.
This issue has occured previously and a restart of SQL resolved the issue and brought the backup time to normal. However on this occassion has not corrected it and would like a more permanent solution and a reason for the issue.
Many Thanks.
July 21, 2006 at 2:59 am
Sorry posted in wrong forum. Should be SQL 2000.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply