Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Cluster failing over but not showing databases


SQL Server Cluster failing over but not showing databases

Author
Message
rohitsharma.aus
rohitsharma.aus
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 45
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
GURSETHI
GURSETHI
SSC Journeyman
SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)

Group: General Forum Members
Points: 96 Visits: 469
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
rohitsharma.aus
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 45
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
GURSETHI
SSC Journeyman
SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)

Group: General Forum Members
Points: 96 Visits: 469
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
rohitsharma.aus
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 45
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

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search