failback reverses a failover. It initiates a manual failback from a logical cluster’s failover resources to its base resources. When initiating a partial-cluster failover, you specify a list of failover resources that are to fail back and a list of base resources to which the failover instances will fail back.
In this example, we incrementally fail back “SalesLC”, which is running on “ase3”, so that “SalesLC” runs on “ase1.” We specify a 2-minute wait.
declare @out_handle varchar(15)
execute sp_cluster logical, "failback", SalesLC, instance, ase3, ase1, wait, "00:02:00", @handle = @out_handle output
