Clustering & AlwaysOn

SQL Server 2014    |    Expert
  • 15 videos | 1h 29m 5s
  • Includes Assessment
  • Earns a Badge
Rating 4.2 of 5 users Rating 4.2 of 5 users (5)
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

  • 7m 56s
    Learn how to identify the interrelationship between AlwaysOn Availability Groups and failover clustering. FREE ACCESS
  • 5m 34s
    After completing this video, you will be able to list the prerequisites for AlwaysOn Availability Groups. FREE ACCESS
  • Locked
    3.  Active Secondary Replicas
    4m 29s
    In this video, learn how to identify the characteristics of active secondary replicas in Always On Availability Groups. FREE ACCESS
  • Locked
    4.  Availability Modes
    3m 52s
    To find out how to identify the availability modes of AlwaysOn Availability Groups, consult the following resources: FREE ACCESS
  • Locked
    5.  Failover Modes
    3m 36s
    In this video, learn how to identify the failover modes of AlwaysOn Availability Groups. FREE ACCESS
  • Locked
    6.  AlwaysOn AG: SSMS Wizard
    12m 31s
    In this video, you will create an AlwaysOn Availability Group using the SSMS wizard. FREE ACCESS
  • Locked
    7.  AlwaysOn AG: SSMS Dialog box
    6m 25s
    In this video, find out how to create an AlwaysOn Availability Group using the SSMS dialog box. FREE ACCESS
  • Locked
    8.  AlwaysOn AG: T-SQL
    5m 2s
    In this video, you will learn how to create an AlwaysOn Availability Group using Transact-SQL. FREE ACCESS
  • Locked
    9.  Joining a Secondary Replica
    5m 27s
    In this video, you will learn how to join a secondary replica to an Always On Availability Group. FREE ACCESS
  • Locked
    10.  Managing Jobs and Logins
    15m 54s
    Learn how to manage jobs and logins for an AlwaysOn Availability Group. FREE ACCESS
  • Locked
    11.  AlwaysOn AG: Manual Failover
    5m 34s
    In this video, find out how to perform a manual failover for an AlwaysOn Availability Group. FREE ACCESS
  • Locked
    12.  Suspending and Resuming
    3m 27s
    Learn how to suspend and resume an AlwaysOn Availability Group. FREE ACCESS
  • Locked
    13.  Removing Primary and Secondary
    3m 23s
    In this video, find out how to remove a primary from an AlwaysOn Availability Group, and how to remove a secondary from an AlwaysOn Availability Group. FREE ACCESS
  • Locked
    14.  Taking a Group Offline
    2m 48s
    In this video, learn how to take an AlwaysOn Availability Group offline. FREE ACCESS
  • Locked
    15.  Removing an AlwaysOn AG
    3m 6s
    In this video, you will learn how to remove an AlwaysOn Availability Group. 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

Rating 4.5 of 61 users Rating 4.5 of 61 users (61)
Rating 4.6 of 75 users Rating 4.6 of 75 users (75)
Rating 4.7 of 37 users Rating 4.7 of 37 users (37)