Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

MS SQL Server 2016/2017 - High Availability

( Duration: 3 Days )

In SQL Server 2016/2017 - High Availability training course, you will 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.

By attending SQL Server 2016/2017 - High Availability workshop, delegates will learn 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 clusters

COURSE AGENDA

1

Characterizing high availability

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

Planned vs. unplanned downtime

  • Performing routine maintenance
  • Recovering from disasters
  • Handling hardware failures
3

Defining components of a cluster

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

Preparing for Windows failover clustering

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

Planning for SQL Server failover clustering

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

Creating a SQL Server failover cluster

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

Preparing for a warm standby server

  • Synchronizing logins
  • Creating network shares
8

Implementing transaction log shipping

  • Specifying log backup frequency
  • Configuring the log shipping monitor
9

Switching to the standby server

  • Redirecting applications
  • Bringing the standby online
10

Comparing mirroring architectures

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

Getting ready for mirroring

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

Mirroring a database

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

Administering mirroring

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

Employing a mirror for reporting

  • Taking a database snapshot
  • Querying a snapshot of the mirror
15

Enhancing the capabilities of database mirroring

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

Clustering and deployment

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

Selecting the appropriate strategies

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

Pulling it all together

  • Creating a complete high-availability solution
  • Evaluating the results

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X