Re: SQL Server 2000 Cluster Manual Failover
- From: mjb9999@xxxxxxxxxxx
- Date: 31 Mar 2006 12:49:16 -0800
I may not have been clear enough. You're right, it isn't that some
resources in the group fail over and others don't (so the group as a
whole doesn't actually fail over), but some of them come online where
the others will not. The SQL Server Network Name, IP Address, and
Physical Disk resources will come online in the second node, but the
SQL Server, SQL Server Agent, and Full Text resources won't come online
unless the MSDTC resource group is running on the node. If MSDTC is
not running on the new node, the group will attempt to fail over. The
3 resources that don't come online stay in a status of "Online
Pending". After trying to come online 3 times, the group will fail
back to the original node. Also, the following 2 errors show up in the
Application event log.
Event Type: Error
Event Source: MSSQL$SQL1
Event Category: (3)
Event ID: 17052
Date: 3/31/2006
Time: 12:31:36 PM
User: N/A
Computer: SQLNODE1
Description:
[sqsrvres] OnlineThread: Error 5b4 bringing resource online.
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: 0b 00 00 00 53 00 51 00 ....S.Q.
0010: 4c 00 53 00 45 00 52 00 L.S.E.R.
0018: 56 00 45 00 52 00 31 00 V.E.R.1.
0020: 00 00 00 00 00 00 ......
Event Type: Error
Event Source: MSSQL$SQL1
Event Category: (3)
Event ID: 17052
Date: 3/31/2006
Time: 12:31:36 PM
User: N/A
Computer: SQLNODE1
Description:
[sqsrvres] OnlineThread: ResUtilsStartResourceService failed (status
5b4)
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: 0b 00 00 00 53 00 51 00 ....S.Q.
0010: 4c 00 53 00 45 00 52 00 L.S.E.R.
0018: 56 00 45 00 52 00 31 00 V.E.R.1.
0020: 00 00 00 00 00 00 ......
.
- References:
- SQL Server 2000 Cluster Manual Failover
- From: mjb9999
- SQL Server 2000 Cluster Manual Failover
- Prev by Date: Re: Service Pack 4 resetting cluster resource settings (affect group)
- Previous by thread: SQL Server 2000 Cluster Manual Failover
- Next by thread: Issues with perfmon
- Index(es):
Relevant Pages
|
