SQL Server Availability Group Configuration with Manual Failover

CREATE AVAILABILITY GROUP 'AG1' WITH (CLUSTER_TYPE = NONE) FOR REPLICA ON 'sqlNode1' WITH ( ENDPOINT_URL = 'tcp://sqlNode1:5022', AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, SEEDING_MODE = AUTOMATIC, FAILOVER_MODE = MANUAL, SECONDARY_ROLE (ALLOW_CONNECTIONS = ALL) ), 'sqlNode2' WITH ( ENDPOINT_URL = 'tcp://sqlNode2:5022', AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, SEEDING_MODE = AUTOMATIC, FAILOVER_MODE = MANUAL, SECONDARY_ROLE (ALLOW_CONNECTIONS = ALL) ), 'sqlNode3' WITH ( ENDPOINT_URL = 'tcp://sqlNode3:5022', AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, SEEDING_MODE = AUTOMATIC, FAILOVER_MODE = MANUAL, SECONDARY_ROLE (ALLOW_CONNECTIONS = ALL) ); GO