Database Reference
In-Depth Information
Click on Apply and then on OK . You will need to restart the service for this change
to take effect. This process needs to be repeated on all instances that are involved in
the Availability Group.
The Availability Group listener
The Availability Group listener is a key to allow your clients to be redirected
automatically in the event of a failover. You can think of the listener as a DNS entry
that points to the primary replica. In the event of a failover, the WSFC updates the
DNS entry to point at the correct primary replica.
For the purposes of this exercise, I have created two virtual machines which will each
act as a node in the AlwaysOn Availability Group. Each node will have 192.168.1.2
and 192.168.1.3 as their IP addresses, respectively. Each will be part of a WSFC
called AlwaysOnCluster and will have 192.168.1.4 as its IP address, and the
listener will be called AlwaysOnDBL and will have 192.168.1.5 as its IP address.
Creating Availability Group
With a Windows cluster built and each node configured for an AlwaysOn
Availability Group, you will learn next to create an Availability Group in SQL Server
2014. You will then build the Availability Group and create a secondary replica using
Microsoft Azure Virtual Machines.
On the instance you initially want to be the primary replica, connect in Management
Studio's Object Explorer , expand the AlwaysOn High Availability folder, right-
click on the Availability Groups folder, and choose Always On Availability
Group Wizard . The first screen explains what the wizard will implement; click on
Next . On the second screen, you will specify a name for your Availability Group; in
this case, it is called AlwaysOnDBs . This can be seen in the following screenshot:
 
Search WWH ::




Custom Search