Log Shipping & High Availability

SQL Server 2016    |    Intermediate
  • 16 videos | 1h 40m 46s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 26 users Rating 4.7 of 26 users (26)
Data is an important enterprise asset and must be protected, retrievable, and highly available. Examine high availability and disaster recovery in SQL Server 2016, including log shipping, shared disks, and cluster shared volumes.

WHAT YOU WILL LEARN

  • 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
    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
    Configure cluster shared volumes
    Manage high availability in sql server 2016

IN THIS COURSE

  • 5m 32s
    Upon completion of this video, you will be able to recognize the purpose and benefits of log shipping. FREE ACCESS
  • 8m 29s
    Learn how to configure log shipping with SQL Server Management Studio. FREE ACCESS
  • Locked
    3.  Configuring Log Shipping with T-SQL
    7m 13s
    Learn how to configure log shipping with Transact-SQL. FREE ACCESS
  • Locked
    4.  Log Shipping Management
    5m 34s
    Upon completion of this video, you will be able to describe log shipping management tasks such as adding databases, removing log shipping, failing over, and changing roles. FREE ACCESS
  • Locked
    5.  Monitoring Log Shipping
    4m 35s
    Upon completion of this video, you will be able to recognize the tables and stored procedures used for monitoring log shipping. FREE ACCESS
  • Locked
    6.  AlwaysOn Availability Groups
    6m 59s
    After completing this video, you will be able to describe the features and benefits of AlwaysOn Availability Groups. FREE ACCESS
  • Locked
    7.  Failover
    7m 36s
    After completing this video, you will be able to describe the purpose of the failover process and the available failover modes. FREE ACCESS
  • Locked
    8.  Windows Server Failover Clustering
    6m 8s
    After completing this video, you will be able to describe the capabilities provided by Windows Server Failover Clustering and how it relates to AlwaysOn components. FREE ACCESS
  • Locked
    9.  Health Monitoring
    7m 22s
    Upon completion of this video, you will be able to describe how high availability is accomplished by monitoring cluster resources. FREE ACCESS
  • Locked
    10.  Creating an Availability Group
    10m 8s
    Learn how to create a new availability group. FREE ACCESS
  • Locked
    11.  Changing the Failover Mode
    3m 14s
    In this video, you will learn how to change the failover mode in an AlwaysOn availability group. FREE ACCESS
  • Locked
    12.  Configuring Read-Only Routing Using T-SQL
    7m 16s
    Learn how to configure read-only routing for an availability group using Transact-SQL. FREE ACCESS
  • Locked
    13.  Distributed Availability Groups
    4m 7s
    Upon completion of this video, you will be able to describe the purpose of distributed availability groups. FREE ACCESS
  • Locked
    14.  Creating a Distributed Availability Group
    5m 6s
    In this video, find out how to create a distributed availability group using Transact-SQL. FREE ACCESS
  • Locked
    15.  Configuring Cluster Shared Volumes
    3m 58s
    Find out how to configure cluster shared volumes. FREE ACCESS
  • Locked
    16.  Exercise: Managing SQL Server 2016 High Availability
    7m 29s
    Find out how to manage high availability in SQL Server 2016. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course CompTIA Server+: Server Storage
Rating 4.6 of 77 users Rating 4.6 of 77 users (77)
Course Microsoft Azure Infrastructure Solutions: Data Solutions
Rating 4.6 of 34 users Rating 4.6 of 34 users (34)
Course Backup Management
Rating 4.5 of 82 users Rating 4.5 of 82 users (82)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Book Pro SQL Server 2019 Administration: A Guide for the Modern DBA, Second Edition
Course Monitoring Database Activity
Rating 4.6 of 29 users Rating 4.6 of 29 users (29)
Course Querying & Manipulating Data
Rating 4.7 of 132 users Rating 4.7 of 132 users (132)