Introduction to High Availability

• Discussion: Why High Availability?
• What Is High Availability?
• Factors Affecting Availability
• Choosing Between High Availability Options

Implementing Log Shipping

• What Is Log Shipping?
• Configuring Log Shipping
• Switching Server Roles

Demo: Configure log shipping to automatically backup and restore transaction logs to another SQL Server
Exercise: Configure log shipping to automatically backup and restore transaction logs to a different SQ

Implementing Server Clustering

• What Is Server Clustering?
• Considerations for Server Clustering
• Installing SQL Server in a Cluster
• Always On SQL Server 2012 Enchancements

Demo: Install a clustered Instance of SQL Server
Exercise: Install a clustered Instance of SQL Server

Implementing AlwaysOn Availability Groups

• AlwaysOn Availability Groups
• Active Secondary Replicas
• Creating an Availability Group
• Managing an AlwaysOn Availability Group
• Creating a Read Only outing

Demo: Creating an AlwaysOn Availability Group
Exercise: Creating an AlwaysOn Availability Group

Using Distributed High Availability Solutions

• Considerations for Peer-to-Peer Replication
• Implementing Distributed Load Balancing
• Implementing Distributed High Availability
• Considerations for Optimizing Database Availability