Live Chat

Scheduling Tool

Training
Training

Harnessing over 40 years in the IT education industry, Learning Tree and its elite team of expert instructors have established the world's best hands-on instructor-led training experience.

Explore Training

Training

Training Courses

Attendee Benefits

Course Tuition

Government Training

Course Delivery

Team Training

Workforce Optimization
Message from the CEO

For 40+ years, Learning Tree has been providing IT and management training to business and government organizations worldwide
Certifications
Certifications

Enhance your credentials and showcase your skills with today’s most popular industry certifications.

Explore Certifications

Certifications
Cyber Security Certifications

View our Cyber Security Learning Paths that include today’s most popular certifications from CompTIA, EC-Council, ISACA and more
Resources
Resources

To help you stay current with new technologies and methodologies that may impact your organization, Learning Tree is always producing complimentary resources using the information gathered by our stout research teams.

Explore Resources

Resources

Defend Your Organization from Cyber Threats through Workforce Optimization Solutions. View brochure ❯
Complimentary Webinar On Demand

Cyber Security: Risk Management for the C-Suite 1 Hour Webinar On Demand: Presented by Richard A. Spires, CEO at Learning Tree
Locations
Locations

With Learning Tree, you have a wide variety of attendance options to ensure you are able get the training you need — whenever and wherever you need it: in-class at an Education Center, online via AnyWare™, or on-site at your preferred location.

Discover Locations

Locations

North America

United Kingdom

France

Sweden

Japan
Live, Online via AnyWare™

Learn more about Learning Tree's live, online attendance platform — AnyWare™

Quick Links

Course Description

You Will Learn How To

SQL Server

Preferred method of contact:

Phone Email

SQL Server High Availability

COURSE TYPE

Advanced

Course Number

141

Duration

3 Days

View Schedule

SQL Server provides a full range of technologies that allow organizations to reduce downtime and maintain high levels of availability. In this training course, you gain experience using SQL Server 2014 AlwaysOn technologies for building a variety of high availability solutions, and learn how to implement failover clustering, log shipping, database mirroring, and peer-to-peer transactional replication.

You Will Learn How To

Design a service level agreement that matches business requirements
Plan, prepare, and install a SQL Server failover cluster
Mirror a database to ensure instant failover
Automate deployment with AlwaysOn technologies
Ensure business continuity through failover cluster

Important Course Information

Requirements:

Experience with database management at the level of:
- Course 8464, Administering Microsoft SQL Server 2014 Databases (20462)
Working knowledge of Windows Server
The ability to backup and recover databases, and manage SQL Server security

Software:

Course exercises use SQL Server 2014, running on Windows Server 2012 Enterprise
This course is applicable to those using earlier versions of SQL Server

Course Outline

High-Availability Fundamentals

Characterizing high availability

The "five nines"
Site
Instance
Database
Defining a service level agreement

Planned vs. unplanned downtime

Performing routine maintenance
Recovering from disasters
Handling hardware failures

Installing Windows 2008 Failover Clustering

Defining components of a cluster

Single-instance architecture
Multi-instance architecture
Shared storage
Resource group
Heartbeat
Quorum

Preparing for Windows failover clustering

Configuring an iSCSI target
Managing shared storage
Installing the failover clustering feature

Establishing SQL Server Failover Clustering

Planning for SQL Server failover clustering

Determining the correct version of Windows Server
Upgrading to SQL Server 2012
Leveraging virtual machines for clustering

Creating a SQL Server failover cluster

Installing a new failover cluster
Adding a new node
Failing over to a passive node

Employing Log Shipping

Preparing for a warm standby server

Synchronizing logins
Creating network shares

Implementing transaction log shipping

Specifying log backup frequency
Configuring the log shipping monitor

Switching to the standby server

Redirecting applications
Bringing the standby online

Configuring Database Mirroring

Comparing mirroring architectures

High availability
High protection
High performance
Full safety vs. safety off

Getting ready for mirroring

Setting the recovery model
Selecting the principal, mirror and witness servers

Mirroring a database

Configuring the principal, mirror and witness servers
Initiating the mirroring session

Administering mirroring

Enabling and disabling mirroring with scripts
Launching the Database Mirroring Monitor (DMM)

Employing a mirror for reporting

Taking a database snapshot
Querying a snapshot of the mirror

AlwaysOn Availability Groups

Enhancing the capabilities of database mirroring

Database mirroring with multiple databases and multiple mirrors
Manually failing over a group of databases

Clustering and deployment

Multi-site clustering across subnets
Automating deployment using AlwaysOn PowerShell cmdlets
Monitoring the high-availability configuration using the AlwaysOn dashboard

Combining High-Availability Technologies

Selecting the appropriate strategies

Determining the pros and cons of each HA technology
Failover clustering with a mirror

Pulling it all together

Creating a complete high-availability solution
Evaluating the results

Show complete outline

Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Aug 16 - 18 Toronto/AnyWare Enroll Now