Syntax

ALTER CLUSTER ( alter_cluster_def [, ...] )

alter_cluster_def syntax 

DROP INSTANCE instance_id
ADD ENDPOINT 'connection_string'
ALTER INSTANCE instance_id ENDPOINT 'connection_string'

Description 

The ALTER CLUSTER command will modify the configuration of the current server cluster. 

connection_string is the ip-number:port-number of a running server instance (eg. '10.0.0.1:999'). 

instance_id is a numerical id unique to the cluster of the server instance to add/drop/alter. These can be found in the "sysinstances" system table. 

ALTER CLUSTER causes and implicit REBUILD ALL within its transaction. 

Note that ALTER CLUSTER will take a long time if you have large databases. 

Examples 

See Clustering Servers Together: Using SQL. 

Related 

• SQL Reference
• Installing a New Server
• Clustering Servers Together
• "sysinstances" System Table