Log Shipping & High Availability

SQL Server 2016    |    Intermediate
  • 16 Videos | 1h 48m 16s
  • Includes Assessment
  • Earns a Badge
Likes 34 Likes 34
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

  • Playable
    1. 
    Log Shipping
    5m 32s
    UP NEXT
  • Playable
    2. 
    Configuring Log Shipping with SSMS
    8m 29s
  • Locked
    3. 
    Configuring Log Shipping with T-SQL
    7m 13s
  • Locked
    4. 
    Log Shipping Management
    5m 34s
  • Locked
    5. 
    Monitoring Log Shipping
    4m 35s
  • Locked
    6. 
    AlwaysOn Availability Groups
    6m 59s
  • Locked
    7. 
    Failover
    7m 36s
  • Locked
    8. 
    Windows Server Failover Clustering
    6m 8s
  • Locked
    9. 
    Health Monitoring
    7m 22s
  • Locked
    10. 
    Creating an Availability Group
    10m 8s
  • Locked
    11. 
    Changing the Failover Mode
    3m 14s
  • Locked
    12. 
    Configuring Read-Only Routing Using T-SQL
    7m 16s
  • Locked
    13. 
    Distributed Availability Groups
    4m 7s
  • Locked
    14. 
    Creating a Distributed Availability Group
    5m 6s
  • Locked
    15. 
    Configuring Cluster Shared Volumes
    3m 58s
  • Locked
    16. 
    Exercise: Managing SQL Server 2016 High Availability
    7m 29s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 34 Likes 34  
COURSE T-SQL Queries
Likes 173 Likes 173  
COURSE Encryption
Likes 96 Likes 96