SQL Server Availability Group Creation: AG1 with Manual Failover and Asynchronous Replication

This script creates an Availability Group named "AG1" with the following configuration:

• The cluster type is set to "NONE", indicating that it is not a clustered Availability Group.
• There are three replicas: "sqlNode1", "sqlNode2", and "sqlNode3".
• Each replica is configured with the following settings:
  • The endpoint URL is set to "tcp://sqlNodeX:5022" where X represents the node number.
  • The availability mode is set to "ASYNCHRONOUS_COMMIT", indicating that asynchronous data replication is used.
  • The seeding mode is set to "AUTOMATIC", allowing automatic seeding of databases to the secondary replicas.
  • The failover mode is set to "MANUAL", indicating that failovers must be initiated manually.
  • The secondary role is configured to allow connections from all clients.

After executing this script, the Availability Group "AG1" will be created with the specified replicas and settings.