March 31, 2011 at 12:10 pm
We have the SQL SERVER 2008 fail over Cluster installed on the Windows Server 2008 r2.There is Power outage to upgrade the system inn data center i.e The boxes need to be shut down completely.
So, Can anyone help me in What way I need to handle this so that after the outage sql server cluster should work fine ..... ?
March 31, 2011 at 4:45 pm
You might want to perform a backup of the databases before it gets shut down, especially if there are going to be changes being done on the database servers or disks. To shut down the cluster I would take the passive node down first (if you have one), then take the active node down. It should all come up fine but you should start the active node first so that the SQL resources are started in that node.
April 1, 2011 at 3:54 am
AK1516 (3/31/2011)
We have the SQL SERVER 2008 fail over Cluster installed on the Windows Server 2008 r2.There is Power outage to upgrade the system inn data center i.e The boxes need to be shut down completely.So, Can anyone help me in What way I need to handle this so that after the outage sql server cluster should work fine ..... ?
I would take all cluster groups offline before shutting down any nodes. By doing this when all nodes are restarted the groups will remain offline and allow you to start the resources on your preferred node(s). Check with your storage admins as to when the storage will become available before attempting to boot the cluster nodes and also ensure the domain controllers are up and serviceable too.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2011 at 8:35 am
As you know in 2008 failover cluster doesnot have the concept of groups as in 2005.I am a bit confused
in bringing the groups offline means bringing the sql server application offline (which is associated with diskdrives,virtual ip,agent service and db engine service) ?
April 1, 2011 at 5:25 pm
Group or application it amounts to the same thing. Either way I would do what I posted above 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2011 at 5:41 pm
Thank you verymuch... 🙂 I am going to implement in that way........
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply