Configure the cluster to automatically recover from an abrupt total cluster failure.
sp_configure "automatic cluster takeover", [1 | 0]
Setting automatic cluster takeover to 1 enables the automatic cluster takeover (the default). Setting it to 0 disables automatic cluster takeover.
See the Starting the Cluster topic for information about manually restarting the cluster.
Environments that have I/O fencing enabled, automatic cluster takeover is guaranteed to be a safe operation. Environments that do not have I/O fencing, a malfunction of the algorithm may introduce data corruption. Therefore, this configuration parameter is present to disable the algorithm if it malfunctions. There is always a risk of data corruption in environments without I/O fencing, and disabling automatic cluster takeover does not mitigate all of those risks.