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 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 56sLearn how to identify the interrelationship between AlwaysOn Availability Groups and failover clustering. FREE ACCESS
-
5m 34sAfter completing this video, you will be able to list the prerequisites for AlwaysOn Availability Groups. FREE ACCESS
-
3. Active Secondary Replicas4m 29sIn this video, learn how to identify the characteristics of active secondary replicas in Always On Availability Groups. FREE ACCESS
-
4. Availability Modes3m 52sTo find out how to identify the availability modes of AlwaysOn Availability Groups, consult the following resources: FREE ACCESS
-
5. Failover Modes3m 36sIn this video, learn how to identify the failover modes of AlwaysOn Availability Groups. FREE ACCESS
-
6. AlwaysOn AG: SSMS Wizard12m 31sIn this video, you will create an AlwaysOn Availability Group using the SSMS wizard. FREE ACCESS
-
7. AlwaysOn AG: SSMS Dialog box6m 25sIn this video, find out how to create an AlwaysOn Availability Group using the SSMS dialog box. FREE ACCESS
-
8. AlwaysOn AG: T-SQL5m 2sIn this video, you will learn how to create an AlwaysOn Availability Group using Transact-SQL. FREE ACCESS
-
9. Joining a Secondary Replica5m 27sIn this video, you will learn how to join a secondary replica to an Always On Availability Group. FREE ACCESS
-
10. Managing Jobs and Logins15m 54sLearn how to manage jobs and logins for an AlwaysOn Availability Group. FREE ACCESS
-
11. AlwaysOn AG: Manual Failover5m 34sIn this video, find out how to perform a manual failover for an AlwaysOn Availability Group. FREE ACCESS
-
12. Suspending and Resuming3m 27sLearn how to suspend and resume an AlwaysOn Availability Group. FREE ACCESS
-
13. Removing Primary and Secondary3m 23sIn 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
-
14. Taking a Group Offline2m 48sIn this video, learn how to take an AlwaysOn Availability Group offline. FREE ACCESS
-
15. Removing an AlwaysOn AG3m 6sIn 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.
