SQL Server Cluster failing over but not showing databases

Question

Post reply

SQL Server Cluster failing over but not showing databases

rohitsharma.aus

SSC Enthusiast

Points: 107
More actions
June 15, 2009 at 9:22 pm

#133228

Hi,
I have an issue on my cluster at the moment. I wanted to replace my old passive node on the cluster with a new box which was exactly the same as the current box in production however fell into quite a hurdle. What happened was the new node was put into the cluster fine it could see all the drives from the san and failed over perfectly, however it just could not see any of hte databases. I confirmed sql and windows were the same and could fail from one node to the other very easily.
I have a feeling it had something to do with the quorum but can not be 100% sure. It was as if this new node on the cluster was working as a standalone server. I even tested it by creating a new database while the new box was the passive node and then failed over to the old box (which was working fine) and could not see the database. I also tried removing it from the cluster and adding it in again however all it could see was the same test database that i created?
Has anyone ever come across this issue?
Cheers

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

GURSETHI SSCommitted Points: 1912 More actions · Answer 1

Hi,

So from your question what I understood is as below.

1) Initially we were having 2 node cluster Node A & Node B.

Node A was active and Node B was passive. We replaced Node B

with a new Physical machie alltogether.

2) We make it part of Windows Cluster (with same name everything

same as previous).

3) We evict Node B from the SQL Server Cluster and then add this

new Node. Everything (means setup) went well.

4) Right now we are not able move SQL Database to newly added

Node.

Please let me know if its correct. If yes then I would say lets have a look to below logs:

Cluster Log (Both Nodes)

Application Event Logs (Saved in Text Delimited Format) (Both Nodes)

System Event Logs (Saved in Text Delimited Format) (Both Nodes)

SQL Server/SQL Agent Logs

We can collect MPSReports for SQL As well for this thing (from both nodes).

Regards

GURSETHI

rohitsharma.aus SSC Enthusiast Points: 107 More actions · Answer 2

Hi Gursethi,

1,2 and 3 were correct however 4 is incorrect. I could fail over and move sql server and the agent over to the new box however when i connected the box from sql management studio I could not see any of the databases,jobs, procs etc that I could see with the other node that was in production from the start.

In the application and event logs there are no problems or errors because the failover runs smoothly however I just can not see the databases.

Cheers

Rohit

ps. I hope taht makes sense. This is why I dont think it was a cluster issue but more of a quorum issue?

GURSETHI (6/15/2009)
Hi,
So from your question what I understood is as below.
1) Initially we were having 2 node cluster Node A & Node B.
Node A was active and Node B was passive. We replaced Node B
with a new Physical machie alltogether.
2) We make it part of Windows Cluster (with same name everything
same as previous).
3) We evict Node B from the SQL Server Cluster and then add this
new Node. Everything (means setup) went well.
4) Right now we are not able move SQL Database to newly added
Node.
Please let me know if its correct. If yes then I would say lets have a look to below logs:
Cluster Log (Both Nodes)
Application Event Logs (Saved in Text Delimited Format) (Both Nodes)
System Event Logs (Saved in Text Delimited Format) (Both Nodes)
SQL Server/SQL Agent Logs
We can collect MPSReports for SQL As well for this thing (from both nodes).
Regards
GURSETHI

GURSETHI SSCommitted Points: 1912 More actions · Answer 3

Cool,

Thanks for this information. Now further to it are we able to connect to Master thru Query Window and run SELECT * FROM SYS.SYSPROCESSES?

In the output are we able to see databases names or not?

Regards

GURSETHI

rohitsharma.aus SSC Enthusiast Points: 107 More actions · Answer 4

Hi mate,

Thanks for the quick response, no we cant see the databases through that query as well?

Cheers

GURSETHI (6/15/2009)
Cool,
Thanks for this information. Now further to it are we able to connect to Master thru Query Window and run SELECT * FROM SYS.SYSPROCESSES?
In the output are we able to see databases names or not?
Regards
GURSETHI