Error on SQL 2000 cluster - 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 2000 Forums

SQL Server Administration (2000)

Error on SQL 2000 cluster

Author

Topic

Joxter
Starting Member

1 Post

Posted - 2008-05-05 : 05:54:54

Hi

I have an issue with a SQL 2000 Cluster. I receive this error on on of the nodes

Event Type: Error
Event Source: MSSQL$PRODUCTION01
Event Category: (2)
Event ID: 17052
Date: 05-05-2008
Time: 10:16:26
User: N/A
Computer: CPHEAVD1-SQL22
Description:
Error: 6002, Severity: 20, State: 1
SHUTDOWN is in progress. Log off.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 72 17 00 00 14 00 00 00 r.......
0008: 1c 00 00 00 43 00 50 00 ....C.P.
0010: 48 00 45 00 41 00 56 00 H.E.A.V.
0018: 44 00 31 00 2d 00 53 00 D.1.-.S.
0020: 51 00 4c 00 32 00 32 00 Q.L.2.2.
0028: 5c 00 50 00 52 00 4f 00 \.P.R.O.
0030: 44 00 55 00 43 00 54 00 D.U.C.T.
0038: 49 00 4f 00 4e 00 30 00 I.O.N.0.
0040: 31 00 00 00 07 00 00 00 1.......
0048: 6d 00 61 00 73 00 74 00 m.a.s.t.
0050: 65 00 72 00 00 00 e.r...

Followed by this one:

Event Type: Error
Event Source: MSSQL$PRODUCTION01
Event Category: (3)
Event ID: 17052
Date: 05-05-2008
Time: 10:16:27
User: N/A
Computer: CPHEAVD1-CLF01
Description:
[sqsrvres] CheckServiceAlive: Service is dead

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 9c 42 00 40 01 00 00 00 ?B.@....
0008: 0f 00 00 00 43 00 50 00 ....C.P.
0010: 48 00 45 00 41 00 56 00 H.E.A.V.
0018: 44 00 31 00 2d 00 53 00 D.1.-.S.
0020: 51 00 4c 00 32 00 32 00 Q.L.2.2.
0028: 00 00 00 00 00 00 ......

This combo shuts one of the named instances off / resulting in a SQL server offline. Can anyone help

Best regards Torben

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2008-05-05 : 14:39:15

Check in the named instance's errorlog to see if there are any interesting errors just before these events in the Windows Event Log. You will likely have to check one of the numbered errorlogs, as they are rotated on each startup.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-05 : 22:16:19

Also check cluster log file for details.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources