SQL 2005 64 Bit job failure
Posted on 2010-01-08
Hello everyone and thank you for your help:
Background: Have a SQL 2005 64bit with one instance with three databases (A,B,C). This is connected to a MS cluster using Windows 2003R2 64 bit SP3. The cluster was at SP and we were getting timeout errors running jobs from database A to B. It was recommended to upgrade to SP3 which we did. Now we get timeout errors from A to B and B to C when running jobs.
Date 1/8/2010 10:13:04 AM
Log Job History (BPW_DAILY_00 - stream 00 hard delete extracts [00:01])
Step ID 3
Job Name BPW_DAILY_00 - stream 00 hard delete extracts [00:01]
Step Name Delete Records in Staging Files
Sql Severity 16
Sql Message ID 16389
Operator Net sent
Retries Attempted 0
Executed as user: server01\APP-PWp. TCP Provider: The semaphore timeout period has expired. [SQLSTATE 08S01] (Error 121) Communication link failure [SQLSTATE 08S01] (Error 121). The step failed.