sp_cluster logical, drop

Drops a logical cluster, or one or more resources from the logical cluster.

sp_cluster logical, "drop",  lc_name, { 
	cluster |
	instance, instance_list |
	 failover, instance_list |
	 route, route_type, key_list }

lc_name – is the name of a logical cluster.

cluster – specifies that the named cluster is to be dropped.

instance – specifies that one or more base instances are to be dropped from the logical cluster.

instance_list – is the list of instances to be dropped. Separate multiple instances with semicolons.

failover – specifies that one or more failover instances are to be dropped from the logical cluster.

route – specifies that one or more routes are to be dropped from the logical cluster.

route_type – is the type of route to be dropped. Values are:

application – specifies a route for an application name to the logical cluster.
login – specifies a route for a login name to the logical cluster.
alias – specifies a route for a server name alias to the logical cluster.

key_list – is a list of applications, logins, or aliases, depending on the route type. Elements in the key list are delimited by colons.

Example 1 Drops the “SalesLC” logical cluster.

sp_cluster logical, "drop", SalesLC, cluster

Example 2 Drops the base instances “ase1” and “ase2” from the “SalesLC” logical cluster.

sp_cluster logical, "drop", SalesLC, instance, "ase1;ase2"

Example 3 Drops the routes from the applications field_sales and web_sales from the “SalesLC” logical cluster.

sp_cluster logical "drop", SalesLC, route, application, "field_sales;web_sales"

You must place an instance or failover resource in the offline state before dropping it.
Dropping a cluster also drops all routes, resources, and settings associated with the cluster.