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.
| 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 AdvanceKRS39 |
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
SQL Instance