How to stop SQL services on both cluster node without failover

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » How to stop SQL services on both cluster node...

How to stop SQL services on both cluster node without failover

Rate Topic

Display Mode

Topic Options

Author

Message

Shivrudra

Posted Friday, February 22, 2013 10:15 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 18, 2013 7:00 AM
Points: 99, Visits: 837

I need to clean stop SQL services and dependent services on Cluster both node without failover for adding new SAN drive,
pls help me and suggest the steps for same

Regards,
Shivrudra W

Post #1423318

Michael Valentine Jones

Posted Saturday, February 23, 2013 2:08 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 12:18 PM
Points: 2,943, Visits: 10,498

Stop the services using the Cluster Administrator application to set them to offline.

Post #1423329

BuntyBoy

Posted Tuesday, March 05, 2013 12:38 PM

Old Hand

Group: General Forum Members
Last Login: Saturday, April 27, 2013 9:30 PM
Points: 392, Visits: 384

you need to freeze the cluster to do this task

===========================================
Better try and fail than not to try at all...

Database Best Practices

SQL Server Best Practices

Post #1426991

Perry Whittle

Posted Wednesday, March 06, 2013 8:10 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,201, Visits: 11,153

BuntyBoy (3/5/2013)

you need to freeze the cluster to do this task

Only if using veritas cluster server, wsfc does not have a freeze action

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1427437

EdVassie

Posted Monday, March 11, 2013 4:49 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 7:57 AM
Points: 2,621, Visits: 2,758

Michael had the answer. Put the SQL Cluster offline using the cluster administrator. This will stop the SQL services.

You can then close down the cluster. Shut down the passive nodes first to prevent the Windows part of the cluster from doing a failover. Then shut down the active node.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.

Post #1429156

« Prev Topic | Next Topic »

Permissions