SQL Server High Availability Training

Nivå: Advanced

Snittbetyg: 4,83/5 Based on 12 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.

Page Sections

Du kommer lära dig att

Utbildningar

Innehåll och datum

FAQs

Relaterade kurser

Börja här

Nyckelfunktioner:

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

FÖRETAGSINTERN UTBILDNING

Teamträning

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 .

Teamträning

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