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

How to stop SQL services on both cluster node without failover Expand / Collapse
Author
Message
Posted Friday, February 22, 2013 10:15 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 8, 2013 9:46 AM
Points: 101, Visits: 842
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
Posted Saturday, February 23, 2013 2:08 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:17 AM
Points: 3,122, Visits: 11,407
Stop the services using the Cluster Administrator application to set them to offline.

Post #1423329
Posted Tuesday, March 5, 2013 12:38 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 6:23 AM
Points: 392, Visits: 405
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
Posted Wednesday, March 6, 2013 8:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:50 AM
Points: 6,189, Visits: 13,338
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"
Post #1427437
Posted Monday, March 11, 2013 4:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:34 AM
Points: 2,859, Visits: 3,187
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.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,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 »

Add to briefcase

Permissions Expand / Collapse