failover from active node to passive node in sql cluster

I would like to failover on sql server 2005 cluster that have active-passive node..sql system are working on the passive node but I want to faiolver it to active node..I dont know how I can do this failover?I logged in the passive node and I opened the cluster administration page..I see the Groups,Resources,cluster configuration and Active and Passive nodes on the Cluster Administration page..could you please tell me how I can failover from passive node to Active node? please as tell me as a detailed
teodor76Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tpi007Commented:
There should be some reource groups setup under groups, right click each one and select move to move to passive cluster. Ensure all groups are moved to passive node. They will be listed as attached to active node and will change after selecting the move option. This is the recommended way; otherwise the brute force way is to shut down/restart the active server which will automatically failover.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.