Two servers setup in Availability Group. One Primary and one Secondary.

Secondary setup as read-only.

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

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.

Last modified: September 19, 2019

Author

Comments

Write a Reply or Comment