Description
In this course, you will learn :
- Create 2 Node Windows Failover Cluster
- Install SQL Server 2016 using GUI & Command Line
- Configure Installed SQL Server Instance for AlwaysOn High Availability
- Create and Configure Availability Grpoups
- Add Database to Availability Group & Replica
- Create and Configure AlwaysOn Availability Group Listener
- Failover Availability Group (Automatic , Manual &Force)
- Configure Backup on Availability Group & Replica
- Monitor AlwaysOn Availability Groups State & Data Syncronization
Syllabus :
- Microsoft SQL Server AlwaysOn Course
- Microsoft SQL Server AlwaysOn Introduction
- Prerequisites, Restrictions & Recommendations
- Install Failover Cluster Feature
- Install SQL Server 2016
- Configure SQL Server Instance for Always On Availability Groups
- Create and Configure Availability Groups
- Add Database to Availability Group & Replicas
- Create AlwaysOn Availability Group Listener (Client Access Point)
- Failover Availability Group
- Configure Backup on Availability Replicas
- Monitor Always On Availability Groups