SQL Server High Availability Training

Nivå: Advanced
Snittbetyg: 4,9/5 4,88/5 Based on 8 Reviews

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.


  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included

Du kommer lära dig att:

  • 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

Välj den utbildningsform som passar dig bäst



  • Använd denna eller någon annan utbildning i ditt företag
  • Fullskalig programutveckling
  • Levereras när, var och hur du vill
  • Blandade utbildningsmodellerSkräddarsytt innehåll
  • Coaching av ett expertteam
View Details ›

Anpassa kurs och innehåll efter teamets behov

Kontakta oss

Utveckla dig och ditt team med anpassade eller öppna kurser alternativt e-learning

Learning Tree erbjuder kundanpassad utbildning hos er, öppna kurser i Stockholm, London eller Washington, möjlighet att delta via våra Anywhere centers (Malmö, Göteborg, Linköping, Stockholm eller Borlänge) eller olika former av e-learning med lärarstöd. Läs mer på www.learningtree.se/priser .


SQL Server High Availability Course Information

  • Course Description

    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

  • High-Availability Fundamentals

    Characterising 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/2012 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

    • Synchronising 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

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.

Questions about which training is right for you?

call 08-506 668 00

Why do we require your location?

It allows us to direct your request to the appropriate Customer Care team.

100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

*Partner-delivered courses may have different terms that apply. Ask for details.

Why do we require your location?

It allows us to direct your request to the appropriate Customer Care team.

Hur föredrar du att bli kontaktad:

Please Choose a Language

Canada - English

Canada - Français