O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building a Multinode AlwaysOn Configuration

Now, let’s build a multinode AlwaysOn configuration, create the clustering configuration, define the availability group, specify the databases roles, replicate the databases, and get our availability group listener up and running, as follows:

1. Verify SQL Server instances are alive and well (exist).

2. Set up WSFC.

3. Prepare the database.

4. Enable AlwaysOn HA.

5. Back up the primary databases.

6. Create the availability group.

7. Select the databases for the availability group.

8. Identify the primary and secondary replicas.

9. Synchronize the data (primary to replica).

10. Set up the listener (availability group listener).

11. Connect using the listener.

12. Fail over to a secondary.

Figure 45.3 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required