The start-up mode attribute specifies whether a logical cluster starts automatically when the cluster starts, or whether the administrator starts it manually.
In automatic mode, a logical cluster starts only when its first base instance comes online following a cluster restart. Thus, a logical cluster does not automatically come online when a failover instance comes online. This is the default value.
In manual mode, a logical cluster comes online only after the administrator executes the online command.
For example, to change the start-up mode for “SalesLC” to manual, enter:
sp_cluster logical, "set", SalesLC, startup, manual