• Online, Self-Paced

Data is an important enterprise asset and it is vital that it be protected, retrievable, and highly available. This course covers managing high availability and disaster recovery in SQL Server 2016. This includes configuring and monitoring log shipping, as well as managing shared disks and configuring cluster shared volumes. In addition, this course covers configuring Windows clustering, creating an availability group and distributed availability groups, configuring read-only routing, and managing failover. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Learning Objectives

Implementing Log Shipping

  • start the course
  • recognize the purpose and benefits of log shipping
  • configure log shipping with SQL Server Management Studio
  • configure log shipping with Transact-SQL
  • describe log shipping management tasks such as adding databases, removing log shipping, failing over, and changing roles
  • recognize the tables and stored procedures used for monitoring log shipping

Implementing AlwaysOn Availability Groups

  • describe the features and benefits of AlwaysOn Availability Groups
  • describe the purpose of the failover process and the available failover modes
  • describe the capabilities provided by Windows Server Failover Clustering and its relationship to AlwaysOn components
  • describe how high availability is accomplished by monitoring cluster resources
  • create a new availability group
  • change the failover mode in an AlwaysOn availability group
  • configure read-only routing for an availability group using Transact-SQL
  • describe the purpose of distributed availability groups
  • create a distributed availability group with Transact-SQL

Working with Shared Volumes

  • configure cluster shared volumes

Practice: Managing High Availability

  • manage high availability in SQL Server 2016

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration

Specialty Areas have been removed from the NICE Framework. With the recent release of the new NICE Framework data, updates to courses are underway. Until this course can be updated, this historical information is provided to give better context as to how it can help you with your cybersecurity goals.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.