Sql Server 2005 Error Message - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Sql Server 2005 Error Message

Author

Topic

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2008-06-12 : 03:58:48

We have use SQL Server 2005 on 64bit windows 2003 server Cluster.
In the application log I noticed the following errors during .
When error occurred , i was copying the 45 GB backup file from this machine to another Network machine over 1Gbps network link.
The sql server database was used by many user. The SQL resorce probably failed in this failover cluster.We could immediately
restart the group.So what could be the cause of the error? anyone has faced this problem ?. Here are the logs in chronology.
Any recommended remedy / parameter change to prevent this further (of course besides not copying full backup file online.
Normally it's done at night in lean times)

------------------------------
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (3)
Event ID: 19019
Date: 6/12/2008
Time: 10:11:11 AM
User: N/A
Computer: XXX
Description:
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 4b 4a 00 40 01 00 00 00 KJ.@....
0008: 08 00 00 00 53 00 51 00 ....S.Q.
0010: 4c 00 43 00 4c 00 55 00 L.C.L.U.
0018: 53 00 00 00 00 00 00 00 S.......
-------------------------------------------------------------------------------------------------
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (3)
Event ID: 19019
Date: 6/12/2008
Time: 10:11:11 AM
User: N/A
Computer: XXX
Description:
[sqsrvres] printODBCError: sqlstate = HYT00; native error = 0; message = [Microsoft][SQL Native Client]Query timeout expired

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 4b 4a 00 40 01 00 00 00 KJ.@....
0008: 08 00 00 00 53 00 51 00 ....S.Q.
0010: 4c 00 43 00 4c 00 55 00 L.C.L.U.
0018: 53 00 00 00 00 00 00 00 S.......
-------------------------------------------------------------------------------------------------
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (3)
Event ID: 19019
Date: 6/12/2008
Time: 10:11:11 AM
User: N/A
Computer: XXX
Description:
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 4b 4a 00 40 01 00 00 00 KJ.@....
0008: 08 00 00 00 53 00 51 00 ....S.Q.
0010: 4c 00 43 00 4c 00 55 00 L.C.L.U.
0018: 53 00 00 00 00 00 00 00 S.......
-------------------------------------------------------------------------------------------------
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (3)
Event ID: 19019
Date: 6/12/2008
Time: 10:11:11 AM
User: N/A
Computer: XXX
Description:
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 4b 4a 00 40 01 00 00 00 KJ.@....
0008: 08 00 00 00 53 00 51 00 ....S.Q.
0010: 4c 00 43 00 4c 00 55 00 L.C.L.U.
0018: 53 00 00 00 00 00 00 00 S.......

-------------------------------------------------------------------------------------------------

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (3)
Event ID: 19019
Date: 6/12/2008
Time: 10:11:27 AM
User: N/A
Computer: XXX
Description:
[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 102; message = [Microsoft][SQL Native Client]TCP Provider: Timeout error [258].

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 4b 4a 00 40 01 00 00 00 KJ.@....
0008: 08 00 00 00 53 00 51 00 ....S.Q.
0010: 4c 00 43 00 4c 00 55 00 L.C.L.U.
0018: 53 00 00 00 00 00 00 00 S.......

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-14 : 17:46:49

Any error in sql server log?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources