HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Restart the active node services without failover

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
withouttheactiverestartnodeservicesfailover

Problem

On a 2 node Windows Server Failover cluster configuration, how do I restart the SQL Server services without failing over to the other node?

Solution

Use the Failover Cluster Manager application to manually stop the services.

This tells the cluster you are intentionally shutting down the service, so it won't attempt to bring it back up on another node.

The Failover Cluster service will wait until you manually bring the service back online using Failover Cluster Manager, where you can decide which node to use to bring the service up.

Context

StackExchange Database Administrators Q#102274, answer score: 8

Revisions (0)

No revisions yet.