SQL Server High Availability and Always On Skills (1 day)


SQL Server offers a number of high availability options. In this course, you will learn how to choose between the options, and how to configure systems to use these options, with just the right amount of depth, within a single day.

During the course, you will learn about Database Mirroring, Log Shipping and Failover Clustering as implemented on many SQL Server systems today, then learn about how SQL Server Availability Groups are implemented.

While our courses are based on SQL Server 2017, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.

 CITY DATES COURSE PRICE EARLY BIRD PRICE
On-demand Please contact us

 



DAY 1 HA301 SQL SERVER HIGH AVAILABILITY OVERVIEW DEFINING HIGH AVAILABILITY AND DISASTER RECOVERY STRATEGIES
Defining High Availability and Disaster Recovery Strategies
Comparing SQL Server HA/DR Technologies
Implementing Disaster Recovery via Log Shipping
Implementing Disaster Recovery via Database Snapshots
LAB: Designing a SQL Server High Availability Solution
DAY 1 HA302 WORKING WITH DATABASE MIRRORING UNDERSTANDING DATABASE MIRRORING
Understanding Database Mirroring
Implementing Database Mirroring
  Monitoring and Troubleshooting Database Mirroring
LAB: Configuring and Managing Database Mirroring
DAY 1 HA303 WORKING WITH FAILOVER CLUSTERING FAILOVER CLUSTERING CORE CONCEPTS
Failover Clustering Core Concepts
Implementing Failover Clustering
Monitoring and Troubleshooting Failover Clustering
LAB: Configuring and Managing Failover Clustering
DAY 1 HA304 WORKING WITH AVAILABILITY GROUPS ALWAYS ON AVAILABILITY GROUPS CORE CONCEPTS
  Always On Availability Groups Core Concepts
Implementing Availability Groups and Listeners
Implementing Active Secondaries
LAB: Configuring and Managing Always On Availability Groups