Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Instance

Author  Topic 

ksr39
Posting Yak Master

193 Posts

Posted - 2014-09-23 : 19:47:25
Hi Experts,

Need a small information about the cluster node's, we have a 3 node cluster server. is it possible to know on which node the SQL Instance was running before all the nodes went down.

we went through a situation where our all 3 nodes went down, now when the server and the services came up, we want to move those Instance to there particular node.

Please help me on this...

Thank you all in advance.

Thank You All In Advance
KRS39

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-24 : 00:52:05
The SQL Server Error Log specifies the node name at startup. So go back to the Error Log before the services went down and check the startup messages.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -