Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

failover the cluster Expand / Collapse
Author
Message
Posted Thursday, September 17, 2009 3:02 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 5:21 AM
Points: 412, Visits: 1,020
how to do the failover the cluster?
Post #789998
Posted Thursday, September 17, 2009 3:11 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 3, 2014 10:59 AM
Points: 626, Visits: 836
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
Post #790002
Posted Thursday, September 17, 2009 3:45 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, May 22, 2014 9:05 AM
Points: 201, Visits: 391
Just go to the Cluster Administrator and do "Move Group".
Post #790010
Posted Friday, September 18, 2009 3:21 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 15, 2014 3:04 AM
Points: 2,728, Visits: 1,116
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.


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #790198
Posted Friday, September 18, 2009 4:11 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 12:30 AM
Points: 353, Visits: 487
and if nothing works, suspend the Services from Primary.

-Forum Etiquette: How to post Performance Problems

-Forum Etiquette: How to post data/code to get the best help
Post #790228
Posted Friday, September 18, 2009 4:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 15, 2014 3:04 AM
Points: 2,728, Visits: 1,116
Vishal Singh (9/18/2009)
and if nothing works, suspend the Services from Primary.


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


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #790233
Posted Friday, September 18, 2009 4:29 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 12:30 AM
Points: 353, Visits: 487
Silverfox (9/18/2009)
Vishal Singh (9/18/2009)
and if nothing works, suspend the Services from Primary.


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

-Forum Etiquette: How to post data/code to get the best help
Post #790240
Posted Friday, September 18, 2009 4:37 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 7:22 AM
Points: 1,327, Visits: 4,506
Vishal Singh (9/18/2009)
Silverfox (9/18/2009)
Vishal Singh (9/18/2009)
and if nothing works, suspend the Services from Primary.


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.



Post #790247
Posted Monday, March 22, 2010 9:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 1, 2012 12:24 PM
Points: 7, Visits: 36

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

Now why didn't I think of that!?!?!
Post #887457
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse