Example of AlwaysOn High Availability Setup

Setup

1. Availability Replicas – Select Server
2. Availability Databases – Select Database
3. Availability Group Listeners – Select Listeners (optional)

Note

Two servers setup in Availability Group. One Primary and one Secondary. (Can have multiple Secondary)

Secondary setup as read-only.

Listener setup as the pointer. Connection string should point to listener. (Optional)

On Primary Server, will display (Primary) next to group name.

On Secondard Server, will display (Secondary) next to group name.

Database will display (Synchronized) next to database name on both primary server and secondary server.