Saturday, February 25, 2012

Communication Link Failure

SQL 7, SP4
windows NT 4, SP6
SQL Server Agent jobs are failing, history
reports "ConnectionRead (SQLState 01000) Message 0
Communication Link Failure (SQL Sate 08S01) (Error 10004)
Jobs have been working fine until yesterday.
DBCC checkdb master, msdb, no errors reported.
I can backup the databases through a third party
application though, so what's up with the ODBC error
message reported by the job history?
Internet searching no help.
Need someone to come to my rescue!"Mary" <Mary_Scheffler@.urscorp.com> wrote in message
news:030e01c3fc16$dc082ff0$3a01280a@.phx.gbl...
> SQL 7, SP4
> windows NT 4, SP6
> SQL Server Agent jobs are failing, history
> reports "ConnectionRead (SQLState 01000) Message 0
> Communication Link Failure (SQL Sate 08S01) (Error 10004)
> Jobs have been working fine until yesterday.
> DBCC checkdb master, msdb, no errors reported.
> I can backup the databases through a third party
> application though, so what's up with the ODBC error
> message reported by the job history?
Check this out -- may be caused if there are pending transactions:
http://support.microsoft.com/defaul...kb;en-us;114630
Steve

No comments:

Post a Comment