January 25, 2012 at 9:41 am
DBA's, I am hoping to get some insight on how to fix this.
Here is what happened:
1. Passive Node was having problems blue screening when it failed over to become active.
2. Windows Admins evicted the node from the cluster.
3. Windows Admins added node back to cluster. Everything with SQL 2008 R2 Standard Ed with only KB2494088 64 bit applied worked
4. I logged in and brought SQL Server and queried the databases with no problem.
5. Tried to failover again and we received blue screen again.
6. Windows Admins evicted the node from the cluster.
7. Windows Admins reinstalled the OS.
8. Windows Admins added node back to cluster.
7. I installed SQL Server 2008 R2 RTM standard ED successfully. It recognized the Instance/Instance ID during the installation.
8. I installed KB2494088 64 bit successfully. I just double clicked on the patch file and ran it.
9. Ran Microsoft SQL Server Discovery Report and it showed only the none clustered software installed at the correct 10.50.1617.0 patch level but no instance/instance id was in the report indicating that it is not clustered.
10. Now I don't know if the installation of the patch messed things up for the cluster. It just doesn't make any sense.
11. I also ran the same discovery report on the active node and it displays the same information indicating that it is not clustered.
12. I ran SSMS on the passive node, connected to the instance and viewed my databases with no problem.
13. We haven't failed the passive node over to become active yet. There are some things that the application owners need to install first. Once that is done, we will test it. However, if there is something that I did wrong I want to fix it before we failover.
I have attached the report. It looks identical on both the active and passive nodes. I wish I had ran the report between the installation of SQL Server and the CU update.
Thanks everyone for your assistance.
Patti 🙂
January 25, 2012 at 12:03 pm
go onto one of the cluster nodes and post the results of this when run from the command prompt
cluster /CLUSTER:yourwindowsclustername NODE /STATUS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2012 at 1:00 pm
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\164937>cluster /CLUSTER:edcluhouma NODE /STATUS
Listing status for all available nodes:
Node Node ID Status
-------------- ------- ---------------------
dbhced01 1 Up
DBHCED02 2 Up
January 25, 2012 at 1:15 pm
Ok so both nodes are part of the windows cluster. Now run the command to list the possible owners of the clustered SQL server resource.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 25, 2012 at 1:20 pm
Sorry perry, I don't know that command.
January 26, 2012 at 4:39 am
Run this and check the results, it will return the cluster groups that are active and the node they're active on
CLUSTER GROUP /NODE:dbhced01
CLUSTER GROUP /NODE:DBHCED02
This will get the cluster group preferred owners, you first need to get a complete list of all cluster groups so use this
CLUSTER GROUP /PROP:name
This will then show preferred owners for an individual group
CLUSTER GROUP yourgroupname /LISTOWNERS
To list possible owners you first need a list of all resources, so use this
CLUSTER RES /PROP:name
Find all the SQL Server resource names from the list and use the following to list possible owners per resource
CLUSTER RES "your sql server res name" /LISTOWNERS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2012 at 2:22 pm
Perry, I hope you are still around. I am really sorry that I couldn't respond sooner.
I have attached a txt file with all the answers.
Please let me know if you see anything weird.
Thanks a bunch.
Patti
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply