May 14, 2012 at 2:44 am
Hi All,
We have a active-passive Windows cluster environment, built on Windows 2003 Enterprise edition. On this cluster, there are 6 SQL 2005 instances residing.
Now, I need to restart one of this SQL instances. I would like to know what is the best way around to restart the SQL instance on this windows cluster environment.
Regards,
Shovan
May 14, 2012 at 2:51 am
Shovan
Go into Cluster Administrator, take the SQL Server resource for the instance in question offline, then bring it back online. Don't forget to ensure that SQL Server Agent starts too. You can do a similar thing in SQL Server Configuration Manager if you prefer.
John
May 14, 2012 at 4:39 am
Hi John,
Thanks a lot for your inputs on this. The issue here is that, the Windows Cluster in being taken care by different vendor and we do not have the rites to access the Cluster Administrator. Also, one question from my side on this - turning the SQL resource offline in Cluster admin - will it not initiate failover to the passive node for the SQL resource ? Please correct me here if I am wrong.
I would like to do it from Configuration manager. Will it be the same procedure that we follow while restarting the SQL service on stand alone servers through Configuration manager ? It would be great if your could share the steps with me.
Best Regards,
Shovan
May 14, 2012 at 4:46 am
Shovan
No, there are two separate options for the cluster resource, which, from memory, are Initiate Failover and Take Offline. The former will fail the resource (the whole group, I think) to the other node. The latter will just turn the resource red in the GUI but won't cause a failover. If you don't have access to Cluster Admin then use the same procedure in Configuration Manager that you would for a stand alone server. I'm not 100% sure that you'll have enough access to do that, given that you don't have access to the cluster resources, but give it a try.
John
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply