September 9, 2010 at 6:19 pm
Hi,
I have installed and configured Failover cluster instance of SQL Server 2008 & SP1 on Windows 2008 Server on node1.
SQL Sevrer 2008 is NOT installed yet on Node2. At this point, what happens if I reboot the Node1?
1. Will the SQL resource group moves to Node2?
2. Since SQL Server is not yet installed on node2, what happens when the SQL resource group moves to Node2? will the instance get corrupted?
Please advice..
Because I would like to reboot node1 once I install SQL Server 2008 and SP1...
Thanks
September 10, 2010 at 1:44 am
The resources would likely try to move to node 2 but won't come online. When node 1 comes back online, you should be able to move the resources back to node 1 without any harm.
I hope you aren't in production with this solution in place and you can safely test this out beforehand.
As always, for safe measure, ensure you have valid backups of your databases before attempting anything you aren't comfortable with.
Regards,
Steve
September 10, 2010 at 2:29 am
if your resource are depending on node 2 when node1 faile then yes, they will switchover to node2 and will try to find reources there and after number of retry if it get failed then it will move back to 1 if its live. Else it will stop the resource and you need to do it manually.
Also if you want to reboot node 1, why not prepare your node 2 first before fail over.
----------
Ashish
September 10, 2010 at 10:51 am
If SQL is not installed on the other node then it will just shut down as it has nowhere to move to. Other cluster resources that are configured to use both nodes will failover.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply