sQL server high availability

The SQL Server High Availability training course offers SQL Server administrators the skills to maintain a large number of constantly available database servers. Delegates learn to implement failover clustering, log shipping, database mirroring and peer-to-peer transactional replication.

By attending SQL Server High Availability workshop, Participants will learn to:

  • Leverage SQL Server technologies to achieve high-availability solutions
  • 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

  • Determining the correct version of Windows Server
  • Upgrading to SQL Server 2012
  • Leveraging virtual machines for clustering
  • Configuring an iSCSI target
  • Managing shared storage
  • Installing the failover clustering feature
  • Single-instance architecture
  • Multi-instance architecture
  • Shared storage
  • Resource group
  • Heartbeat
  • Quorum
  • Performing routine maintenance
  • Recovering from disasters
  • Handling hardware failures
  • The "five nines"
  • Site
  • Instance
  • Database
  • Defining a service level agreement
  • Installing a new failover cluster
  • Adding a new node
  • Failing over to a passive node
  • Synchronizing logins
  • Creating network shares
  • Specifying log backup frequency
  • Configuring the log shipping monitor
  • Redirecting applications
  • Bringing the standby online
  • High availability
  • High protection
  • High performance
  • Full safety vs. safety off
  • Setting the recovery model
  • Selecting the principal, mirror and witness servers
  • Configuring the principal, mirror and witness servers
  • Initiating the mirroring session
  • Enabling and disabling mirroring with scripts
  • Launching the Database Mirroring Monitor (DMM)
  • Taking a database snapshot
  • Querying a snapshot of the mirror
  • Database mirroring with multiple databases and multiple mirrors
  • Manually failing over a group of databases
  • Multi-site clustering across subnets
  • Automating deployment using AlwaysOn PowerShell cmdlets
  • Monitoring the high-availability configuration using the AlwaysOn dashboard
  • Determining the pros and cons of each HA technology
  • Failover clustering with a mirror
  • Creating a complete high-availability solution
  • Evaluating the results