- Log in to one of the SQL servers.
- Access the Availability Group Wizard window.
- Expand AlwaysOn High Availability.
- Right-click Availability Groups, and then select New Availability Group Wizard.
The New Availability Group window appears, displaying the Introduction section.
- Select Next.
The Specify Availability Group Name section appears.
- Enter a name for the group, and then select Next.
The Select Databases section appears.
- Select the check boxes for the databases that you want to include in the group, and then select Next.
The Specify Replicas section appears.
- Select Add Replica, add replicas for the servers, and then select Endpoints.
Note:
- You can set up automatic failover for a maximum of two replicas.
- You can set up synchronous commit for a maximum of three replicas.
The Endpoints subsection appears.
- In the Port Number column, provide an open port number for each server, and then select Listener.
The Listener subsection appears.
- Provide values in the Listener DNS Name and Port boxes, add a static IP address, and then select Next.
The Select Data Synchronization section appears.
- Select Full, and then provide the path of the shared folder, which will be used to store backup files while restoring data in the replicas at the initial stage.
- Select Next.
The Validation section appears, displaying the results of the availability group validation.
- Select Next.
The Summary section appears.
- Review the summary, and then select Finish.
The AlwaysOn Availability group is created.