SQL Server 2014 High Availability 3 days | | $1,785 PLUS TAX

This course provides an in-depth review of SQL Server 2014 High Availability, including concepts for HA, drill-through of the various technologies available with SQL Server 2014, and how to implement high availability using those technologies. Prerequisite:

COURSE OBJECTIVES

Upon completion of this course, the student will be able to:

» Design a SQL Server 2014 availability solution to meet their availability goals.
» Implement that design using the available technologies in SQL Server 2014.
» Implement system maintenance while understanding the availability implications.
» Troubleshoot problems with High Availability in SQL Server 2014.

COURSE OUTLINE

HIGH AVAILABILITY OVERVIEW

» Defining High Availability
» Achieving High Availability

OVERVIEW OF WINDOWS SERVER FAILOVER CLUSTERING

» Failover Clustering Concepts
» Cluster Resources
» Setting up a Windows Failover Cluster
» MSDTC Clustering
» LAB: Creating Your Windows Server Failover Cluster

SQL SERVER 2014 HIGH AVAILABILITY OVERVIEW

» SQL Server 2014 High Availability (HA) Technologies
» High-level Considerations on Technology Choices
» Common Combinations

ALWAYSON FAILOVER CLUSTERING

» SQL Server Failover Clustering – Definitions and History
» SQL Server 2014 Failover Clustering Instance (FCI)
» Maintaining a SQL Server 2014 FCI
» Multi-Site Failover Clustering
» LAB: Installing a Two-Node Failover Clustered SQL Server and Analysis Services Installation

ALWAYSON AVAILABILITY GROUPS

» Availability Group Concepts
» Partners and Secondary Servers
» LAB A: Creating an Availability Group Hosted on Three Servers: Primary, Synchronous Secondary, and Asynchronous Secondary
» LAB B: Database Backups for Secondary Replicas: Creating Automated Database Backups on All Secondary Replicas

LEGACY DATABASE MIRRORING

» Database Mirroring Overview
» Database Mirroring Architecture
» Enabling Database Mirroring
» Database Mirroring Operations
» LAB: Enabling Database Mirroring Between Two Servers

LEGACY LOG SHIPPING

» Log Shipping Overview
» Log Shipping Architecture
» Configuring Log Shipping
» Log Shipping Internals
» Administering Log Shipping
» LAB: Enabling Log Shipping Between Two Servers

USING REPLICATION FOR HIGH AVAILABILITY

» Replication Overview
» Replication Types
» Replication Architecture
» Configuring Replication
» Replication Monitoring
» LAB: Enabling Transactional Replication with Three Servers

HIGH AVAILABILITY SOLUTIONS INTEROPERABILITY

» AlwaysOn Failover Cluster Instances with AlwaysOn Availability Groups
» AlwaysOn Failover Cluster Instances with Legacy Database Mirroring
» AlwaysOn Availability Groups with Replication
» LAB: Creating AlwaysOn Availability Groups Running a Primary Replica on an AlwaysOn Failover Cluster Instance