• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 847
  • Last Modified:

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
1 Solution
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now