SQL 2008 cluster: manual failover

[web4fun]

Window 2008 Enterprise servers with SQL 2008 servers in a 2 node cluster. Just applied SP 1 to to one node that I've excluded from the cluster per instruction but now need to update the other node, thus I added the node back as a possible cluster owner but I haven't been able to figure out how to force a manual failover to the other node so that I can update SP1 on the remaining node aside from a reboot.

Is it in SQL Config Mgr somewhere?

Thanks in advance.

 

[mrdenny]

You'll need to open the Failover Cluster Manager and right click on the application group listed there and select move group.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog