O'Reilly logo

Getting Started with SQL Server 2014 Administration by Gethyn Ellis

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

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 ...

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