December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 UnleashedBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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.