Book Image

Getting Started with SQL Server 2014 Administration

By : Gethyn Ellis
Book Image

Getting Started with SQL Server 2014 Administration

By: Gethyn Ellis

Overview of this book

Table of Contents (13 chapters)
Getting Started with SQL Server 2014 Administration
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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:

On the next screen, you will choose which databases to include in your Availability Group. In this example, two databases called DB1 and DB2 will form the databases in the Availability Group. There are some prerequisites...