SQL Server provides a full range of technologies that allow organisations to reduce downtime and maintain high levels of availability. In this SQL Server High Availability training course, you gain experience using SQL Server 2017 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.
Save More on Training with Learning Tree Training Vouchers!
Our flexible, easy-to-redeem training vouchers are available to any employee within your organisation. For details, please call 0800 282 353 or chat live.
In Class & Live, Online Training
Note: This course runs for
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.
SQL Server High Availability Course Information
In this 3-day SQL Server High Availability course, you learn to maintain a large number of constantly available database servers to ensure disaster recovery.
SQL Server High Availability Course Outline
Characterising high availability
The "five nines"
Defining a service level agreement
Planned vs. unplanned downtime
Performing routine maintenance
Recovering from disasters
Handling hardware failures
Installing Windows 2008/2012 Failover Clustering
Defining components of a cluster
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
Creating network shares
Implementing transaction log shipping
Specifying log backup frequency
Configuring the log shipping monitor
Switching to the standby server
Bringing the standby online
Configuring Database Mirroring
Comparing mirroring architectures
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
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
SQL Server High Availability Training FAQs
What is SQL Server High Availability?
SQL Server High Availability allows 24 hour access to its database if any problem were to arise and you need immediate solutions.
What version of SQL Server is this High Availability course applicable to?
The applicable version for this course is SQL Server 2017.
Can I learn SQL Server High Availability online?
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want, including online training.