Building and Managing High Availability Solutions with SQL Server 2016 and 2014

Price
$1,785.00

Duration
3 Days

Delivery Methods
VILT Private Group

This is a High-Availability course for the real-world. You’ll learn the essentials for buliding and managing a reliable high availability solution.

Upcoming Class Dates and Times

Coming Soon:
The next class is currently being scheduled. Need it now? No problem.
Contact us and we will help you get the training you need!

Who Should Attend

Those responsible for building and managing high availability solutions for SQL Server.

Course Objectives

Build a reliable High Availability solutionwith Windows Server 2012 R2/2016 and SQL Server 2014/2016 Manage a High Availability solution with Windows Server 2012 R2/2016 and SQL Server 2014/2016 Build Disaster Recovery Solutions Troubleshoot problems with High Availability in SQL Server 2016 and 2014

Agenda

1 - Introduction to High Availability

Basic aspects of High Availability

2 - Windows Server 2016 High Availability Features Overview

Overview of HA features in Windows Server 2016

3 - SQL Server 2016 High Availability Features Overview

Failover Cluster Instances
Availability Group
Log Shipping

4 - Windows Server 2016 Failover Clustering

Installation
Storage configuration
Quorum configuration
Maintenance
Patching/Upgrading
Adding/Removing nodes to/from cluster
Monitoring
Troubleshooting

5 - SQL Server 2016 Failover Clustering Instance

SQL Server FCI configuration
Active/Active
Active/Passive
MS DTC
Maintenance
Patching/Upgrading
o Adding/Removing SQL Server to/from cluster
Monitoring
Troubleshooting

6 - SQL Server 2016 Availability Groups

SQL Server AG configuration
Sync/Async
Read Only Routing and Load Balancing
Direct seeding
Distributed AG
Maintenance
Patching/Upgrading
Adding/Removing files to/from database in AG
Adding/Removing database to/from AG
Monitoring
Troubleshooting

7 - SQL Server Interoperability

Interoperability
with Integration Services
with Analysis Services
with Reporting Services

Prerequisite Courses Recommended

20462 Administering Microsoft® SQL Server® Databases