Description

This course will teach you how to choose and implement the best high availability and disaster recovery strategy with SQL Server 2012/2014. You will see the different types of replicas, the latest enhancements as well as the geographically dispersed server cluster solution.

Who is this training for ?

For whom ?

Prerequisites

Training objectives

Understand the principles of high availability solutions offered in SQL Server Know the prerequisites and essential conditions for setting up an AlwaysOn failover cluster Configure a disaster recovery solution with Always On availability groups Implement a log shipping solution Identify the advantages and limitations of other availability solutions offered in SQL Server

Training program

• Comparison of high availability solutions
  • Definition of HADR, High Availability and Disaster Recovery.
  • Comparison of the solutions offered in SQL Server.
• AlwaysOn Failover Cluster Instances (Clustering Services)
  • AlwaysOn Failover Cluster Instances (Clustering Services)
• Always On Availability Groups, disaster recovery solution
  • Operating principles, difference with the mirror in previous versions.
  • The different types of replicas.
  • Synchronous-asynchronous validation modes.
  • Using the listener for client redirection.
  • Securing the TCP channel.
  • Monitoring with dynamic management views and performance counters.
  • Improvements in SQL Server 2014.
  • Manage manual failover.
  • Practical work Setting up an Always On availability group.
• Other high availability methods
  • Using replication for high availability.
  • Copying backup files with log shipping.
  • Using the Broker service with AlwaysOn availability groups.
  • Hardware solutions.
  • Third-party software offers.
  • Geo-cluster, geographically dispersed server clusters.
  • Practical work Implementation of a log shipping solution.