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
Saturday, February 25, 2012
Communication Link Failure
Labels:
0communication,
agent,
communication,
connectionread,
database,
failing,
failure,
historyreports,
jobs,
link,
message,
microsoft,
mysql,
oracle,
server,
sp4windows,
sp6sql,
sql,
sqlstate
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment