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