Reverses a manual failover, reinstating the original base instances.
sp_cluster logical, “failback”, lc_name, {
cluster[, wait_option[, timeout[, @handle output ]]] |
instance, from_instance_list, to_instance_list[, wait_option[,
timeout[, @handle output ]]] }
lc_name – is the name of a logical cluster.
cluster – specifies a failback of the entire logical cluster.
to_instance_list – is a list of predefined failover instances. A value of NULL activates the first failover group.
wait_option – is how the time of the action is to be recorded. Values are:
wait – indicates that existing connections are given a specified amount of time (or an infinite amount of time if no timeout is given) to migrate or disconnect.
nowait – indicates that existing connections are migrated or disconnected immediately.
until – indicates that existing connections are given until a specific time of day to migrate or disconnect.
timeout – is a specific amount of time (when used with wait) or a specific time (when used with until). The format is "hh:mm:ss" according to a 24-hour clock. For example, timeout records 11:30 pm as 23:30:00.
@handle output – specifies that an action handle is to be retrieved for the failback.
instance – specifies that only selected instances in the logical cluster are to fail back.
from_instance_list – is a list of instances that are to be taken offline.
Example 1 Fails back the “SalesLC” logical cluster.
sp_cluster logical, "failback", SalesLC, cluster
Example 2 “SalesLC” is running on “ase3” and “ase1”. In this example, “ase3” fails back to “ase1”, and “SalesLC” continues to run on “ase2”. The action takes place in two minutes.
declare @out_handle varchar(15)
execute sp_cluster logical, "failback", SalesLC, instance, ase3, ase1, wait, "00:02:00", @handle = @out_handle output
To initiate a failback, the logical cluster must first be failed over.
