SQL Server High Availability Training
COURSE TYPE
Advanced
Course Number
141
Duration
3 Days
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
Convenient Ways to Attend This Instructor-Led Course
Hassle-Free Enrollment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.
In the Classroom
Live, Online
Private Team Training
In the Classroom — OR — Live, Online
Tuition — Standard: $2650 Government: $2355
Aug 16 - 18
(3 Days)
9:00 AM - 4:30 PM EDT
Toronto / Online (AnyWare)
Reserve Your Seat
Aug 30 - Sep 1
(3 Days)
9:00 AM - 4:30 PM EDT
Online (AnyWare)
Reserve Your Seat
Sep 20 - 22
(3 Days)
9:00 AM - 4:30 PM EDT
Ottawa / Online (AnyWare)
Reserve Your Seat
Nov 15 - 17
(3 Days)
9:00 AM - 4:30 PM EST
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Feb 7 - 9
(3 Days)
9:00 AM - 4:30 PM EST
Toronto / Online (AnyWare)
Reserve Your Seat
Feb 28 - Mar 2
(3 Days)
9:00 AM - 4:30 PM EST
Ottawa / Online (AnyWare)
Reserve Your Seat
May 16 - 18
(3 Days)
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Reserve Your Seat
Guaranteed to Run
Private Team Training
Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.
For details, call 1-888-843-8733 or Click Here »
Tuition
Standard
Government
In Classroom or
Online
Standard
$2650
Government
$2355
Private Team Training
Course Tuition Includes:
Training Hours
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm
FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:
- Have a record of your growth and learning results
- Bring proof of your progress back to your organization
- Earn credits toward industry certifications (if applicable)
Enhance Your Credentials with Professional Certification
Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.
Earn 17 Credits from NASBA
This course qualifies for 17 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...