Skip to content
CBT Nuggets

Microsoft SQL Server 2016 High Availability and Disaster Recovery

This Microsoft SQL Server 2016 High Availability and Disaster Recovery training covers how to provide consistent, high-speed access to data. Topics include Log Shipping, Windows Clustering, Availability Groups, and failover management. This SQL course deal for database admins looking to ensure business continuity and minimal downtime.

Updated March 2021

3Skills
15Videos
3Virtual Labs
2h 3mTotal
15 videos3 labs2h 3m

Who This Course Is For

This SQL Server 2016 High Availability and Disaster Recovery training is considered associate-level Microsoft training, which means it was designed for systems administrators. This SQL Server 2016 skills course is valuable for new IT professionals with at least a year of experience with server HA and DR administration and experienced systems administrators looking to validate their Microsoft skills.

Skills Your Team Will Gain

  • Providing essential business continuity solutions for company data
  • Allowing work to continue in the event of outages or unforeseen calamity
  • Configuring and monitoring Log Shipping
  • Configuring Windows clustering and availability groups
  • Managing failover

Course Curriculum

  • Premium skill.Implement Log Shipping in SQL Server 201634m + 1 lab
  • Premium skill.Implement Always On Availability Groups in SQL Server 201654m + 1 lab
  • Premium skill.Implement Failover Cluster Instances in SQL Server 201634m + 1 lab

Readiness check

Confirm prerequisite knowledge before training begins

A short placement assessment on the CBT Nuggets assessments platform measures whether a learner already has the foundation this course assumes. IT Directors use it to put the right people in the right training — and any learner can take it right now to make sure they'll get full value from day one.

  • Questions generated from this course's own lesson transcripts — what gets measured is exactly what gets taught
  • Instant, per-learner results that show whether the prerequisite foundation is in place
  • Results roll up into team readiness reporting, so training hours go where they change outcomes

Runs on assessments.cbtnuggets.com — sign in with an Adept account so results roll up into team readiness reporting. Need one? Create an Adept account.

This course is included with every subscription

Get your team access to all 559 courses, virtual labs, and practice exams.

Most Popular

Team

$749per seat / year

5+ learner seats

Get Started

Enterprise

Customannual contracts

Any size

Contact Enterprise Sales

Just need this course?

Single-course enrollment — $99 for 1 year of access to SQL Server 2016 High Availability and Disaster Recovery Online Training.

Enroll in This Course
Calculate the ROI of training your team

Trusted by 23,000+ organizations

Frequently Asked Questions

Ready to upskill your team?

Talk to our sales team to find the right plan for your organization.