8. Clustering & AlwaysON

8. Clustering & AlwaysON

1. Clustering SQL Server 2012

   • Fulfilling Edition Prerequisites
     • Windows Server 2008 R2 as Shared Storage
     • Connecting to the SAN by Using iSCSI Initiator
   • Creating a Windows Server 2008 R2 Failover Cluster
   • Installing a SQL Server Failover Cluster
   • Multi-Subnet Failover Clustering
   • Performing Manual Failover
   • Troubleshooting Failover Cluster

2. AlwaysOn Availability Groups

   • What Are AlwaysOn Availability Groups?
   • Meeting Availability Group Requisites
   • Configuring Availability Modes
   • Selecting Failover Modes
     • Automatic Failover
     • Planned Manual Failover
     • Forced Manual Failover
   • Configuring Readable Secondary Replicas
   • Deploying AlwaysOn Availability Groups
     • Creating an AlwaysOn Endpoint
     • Enabling AlwaysOn Availability Groups
     • Creating an Availability Group
     • Creating or Adding an Availability Group Listener
     • Adding Secondary Replicas
   • Using Availability Groups on Failover Cluster Instances