The focus of this one-day Microsoft training course is on how to plan and implement high availability and disaster recovery solutions.
SQL Server 2014 is closely integrated with the Windows Server Failover Clustering feature in Windows Server 2012 and Windows Server 2012 R2, enabling you to create enterprise-class clustering solutions that can deliver comprehensive high availability and disaster recovery solutions. This module explains how Windows Server Failover Clustering and SQL Server AlwaysOn Failover Cluster Instances work, and describes how to implement clustering to protect service availability.
Lessons
- High Availability Concepts and Options
- Introduction to Windows Server Failover Clustering
- SQL Server AlwaysOn Failover Cluster Instances
Lab : Implementing an AlwaysOn Failover Cluster Instance
- Inspect the Windows Server Failover Cluster Configuration
- Install an AlwaysOn Failover Cluster Instance
- Configure tempdb to Use Local Storage
- Test Automatic Failover and Failback
- Describe the key benefits and features of Windows Server Failover Clustering.
- Describe how to use SQL Server AlwaysOn Failover Cluster Instances to maintain high availability for SQL Server instances.
SQL Server 2014 includes AlwaysOn Availability Groups to provide high availability for groups of databases. This module describes AlwaysOn Availability Groups in SQL Server 2014, explains the key concepts of AlwaysOn Availability Groups, and describes how you can use them to maintain highly available databases.
Lessons
- Introduction to AlwaysOn Availability Groups
- Working with AlwaysOn Availability Groups
- Considerations for Using AlwaysOn Availability Groups
Lab : Implementing and Testing an AlwaysOn Availability Group
- Implementing an AlwaysOn Availability Group
- Connecting to an AlwaysOn Availability Group
- Testing Failover
- Configure Quorum Voting
- Describe the fundamental concepts and terminology for AlwaysOn Availability Groups.
- Explain how work with AlwaysOn Availability Groups.
This module describes the planning considerations for high availability and disaster recovery, and provides common implementation scenarios for on-premises, hybrid, and Windows Azure environments.
Lessons
- High Availability and Disaster Recovery with SQL Server 2014
- High Availability and Disaster Recovery for Databases in Windows Azure
Lab : Planning High Availability and Disaster Recovery
- Planning High Availability and Disaster Recovery Solutions with SQL Server 2014
- Planning High Availability and Disaster Recovery Solutions by Using Windows Azure
- Explain the considerations for implementing high availability and disaster recovery by using SQL Server 2014, and describe some common scenarios.
- Explain the considerations for implementing high availability and disaster recovery by using SQL Server 2014 and Windows Azure services, and describe some common scenarios.
This Microsoft training course is intended for database professionals who need to plan, implement, and manage database solutions. Primary responsibilities include:
- Describe high availability technologies in SQL Server 2014 and implement log shipping.
- Describe Windows Server Failover Clustering and implement an AlwaysOn Failover Cluster Instance.
- Implement and AlwaysOn Availability Group.
- Plan high availability and disaster recovery solutions.
About Microsoft On-Demand Learning
Build your Microsoft technical expertise while balancing the demands of your schedule. The new MOC On-Demand series courses combine high-quality video lectures, live hands-on labs and knowledge-checks in a self-paced format to help you build skills as your schedule allows—all at once or five minutes at a time.
MOC On-Demand at a Glance
Self-Paced Learning
The modular structure offered by MOC On-Demand courses lets learners complete training piecemeal or in an order they choose.
Immediate Feedback on Mastery
Knowledge checks at the end of each module and each course tell learners whether they’ve mastered the content and are ready to move on.
SATV Eligible
Similar to In-class Microsoft official curriculum courses, MOC On-Demand is eligible for payment via Software Assurance Training Vouchers (SATVs)
Direct From the Source
MOC On-Demand is brought to you by the people who wrote the software. The content is based on the official Microsoft official curriculum (MOC).
Learn Anywhere Anytime
The high-quality in-depth video content, labs and knowledge checks are all available to you via the cloud 24 X 7.
Live Hands-on
Labs
Unlike other on-demand offerings that offer simulated labs, MOC On-Demand gives customers a live, real-time environment for hands-on training.
OLLAnywhere is a revolutionary way of utilising cutting-edge technology to allow students to attend live instructor-led training from anywhere in or outside of Australia.