Clustering & AlwaysOn

SQL Server 2014    |    Expert
  • 15 videos | 1h 29m 5s
  • Includes Assessment
  • Earns a Badge
Likes 13 Likes 13
SQL Server AlwaysOn Availability Groups are built on WSFC clusters and AlwaysOn Failover Cluster Instances (FCI). Discover how to create, configure, and manage SQL Server AlwaysOn FCIs and AlwaysOn Availability Groups.

WHAT YOU WILL LEARN

  • identify the interrelationship between AlwaysOn Availability Groups and clustering
    list the prerequisites for AlwaysOn Availability Groups
    identify the characteristics of active secondary replicas in AlwaysOn Availability Groups
    identify the availability modes of AlwaysOn Availability Groups
    identify the failover modes of AlwaysOn Availability Groups
    create an AlwaysOn Availablity Group using the SSMS wizard
    create an AlwaysOn Availablity Group using the SSMS dialog box
    create an AlwaysOn Availablity Group using Transact-SQL
  • join a secondary replica to an AlwaysOn Availability Group
    manage jobs and logins for an AlwaysOn Availability Group
    perform a manual failover for an AlwaysOn Availability Group
    suspend and resume an AlwaysOn Availability Database
    remove a primary from an AlwaysOn Availability Group, and remove a secondary from an AlwaysOn Availability Group
    take an AlwaysOn Availability Group offline
    remove an AlwaysOn Availability Group

IN THIS COURSE

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 AWS Cloud Practitioner 2022: Cloud Deployment & Operation
Course Microsoft Azure Fundamentals: Managing the Hierarchy
Book SQL Server Big Data Clusters: Data Virtualization, Data Lake, and AI Platform, Second Edition