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