Clustering & AlwaysOn
SQL Server 2014
| Expert
- 15 videos | 1h 29m 5s
- Includes Assessment
- Earns a Badge
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 clusteringlist the prerequisites for AlwaysOn Availability Groupsidentify the characteristics of active secondary replicas in AlwaysOn Availability Groupsidentify the availability modes of AlwaysOn Availability Groupsidentify the failover modes of AlwaysOn Availability Groupscreate an AlwaysOn Availablity Group using the SSMS wizardcreate an AlwaysOn Availablity Group using the SSMS dialog boxcreate an AlwaysOn Availablity Group using Transact-SQL
-
join a secondary replica to an AlwaysOn Availability Groupmanage jobs and logins for an AlwaysOn Availability Groupperform a manual failover for an AlwaysOn Availability Groupsuspend and resume an AlwaysOn Availability Databaseremove a primary from an AlwaysOn Availability Group, and remove a secondary from an AlwaysOn Availability Grouptake an AlwaysOn Availability Group offlineremove an AlwaysOn Availability Group
IN THIS COURSE
-
1.AlwaysOn Clustering7m 56sUP NEXT
-
2.AlwaysOn AG Prerequisites5m 34s
-
3.Active Secondary Replicas4m 29s
-
4.Availability Modes3m 52s
-
5.Failover Modes3m 36s
-
6.AlwaysOn AG: SSMS Wizard12m 31s
-
7.AlwaysOn AG: SSMS Dialog box6m 25s
-
8.AlwaysOn AG: T-SQL5m 2s
-
9.Joining a Secondary Replica5m 27s
-
10.Managing Jobs and Logins15m 54s
-
11.AlwaysOn AG: Manual Failover5m 34s
-
12.Suspending and Resuming3m 27s
-
13.Removing Primary and Secondary3m 23s
-
14.Taking a Group Offline2m 48s
-
15.Removing an AlwaysOn AG3m 6s
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.