failover the cluster

Question

Post reply

failover the cluster

charipg

SSCrazy Eights

Points: 9888
More actions
September 17, 2009 at 3:02 pm

#136054

how to do the failover the cluster?

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

SQLBOT SSCrazy Eights Points: 8014 More actions · Answer 1

Are you using Microsoft clustering or a third party like Veritas (VCS) ?

~BOT

Craig Outcalt

Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258

Sergey Vavinskiy SSCarpal Tunnel Points: 4469 More actions · Answer 2

Just go to the Cluster Administrator and do "Move Group".

Silverfox SSC-Insane Points: 23150 More actions · Answer 3

Sergey Vavinskiy (9/17/2009)
Just go to the Cluster Administrator and do "Move Group".

you can also use cluster.exe to do this as well

That is one way, quite a generalised question and answer. the cluster can also failover if a cluster resource fails and it is set to affect the group. if the cluster is set to automatic failover.

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 4

and if nothing works, suspend the Services from Primary.:hehe:

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Silverfox SSC-Insane Points: 23150 More actions · Answer 5

Vishal Singh (9/18/2009)
and if nothing works, suspend the Services from Primary.:hehe:

LOL, the op has enough answers, dont confuse any further.

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 6

Silverfox (9/18/2009)
Vishal Singh (9/18/2009)
and if nothing works, suspend the Services from Primary.:hehe:
LOL, the op has enough answers, dont confuse any further.

no confusion silverfox, I said if nothing works. 😀

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Ian Scarlett SSC-Insane Points: 23197 More actions · Answer 7

Vishal Singh (9/18/2009)
Silverfox (9/18/2009)
Vishal Singh (9/18/2009)
and if nothing works, suspend the Services from Primary.:hehe:
LOL, the op has enough answers, dont confuse any further.
no confusion silverfox, I said if nothing works. 😀

You missed the easiest way of all... pull the plug out.:w00t:

hugericc Old Hand Points: 397 More actions · Answer 8

You missed the easiest way of all... pull the plug out.:w00t:[/quote]

Now why didn't I think of that!?!?!