Retour aux formations
Autre
Building and Managing High Availability Solutions with SQL Server
3 jour(s) • 21h
Description
This advanced course provides hands-on expertise for deploying and managing high availability solutions using SQL Server and Windows Server. Participants will gain the skills to configure, maintain, and troubleshoot failover clusters, availability groups, and disaster recovery strategies in production environments.
Objectifs pédagogiques
- Understand core concepts of high availability and disaster recovery
- Configure Windows Server Failover Clustering (WSFC)
- Deploy SQL Server Failover Cluster Instances (FCI) and Availability Groups (AG)
- Maintain and troubleshoot HA environments
- Implement interoperability with other SQL Server services
Public concerné
Database administrators
system engineers
Prérequis
Solid experience with Microsoft SQL Server administration
Familiarity with Windows Server concepts
Basic understanding of networking and Active Directory services
Déroulé du programme
1
Module 1 – Introduction to High Availability
- Overview of HA concepts
- Business continuity goals: RPO, RTO
- Comparison of SQL Server HA/DR features
- Lab: Simulate SQL Server service failure and evaluate impact
2
Module 2 – High Availability Features in Windows Server 2019
- Failover Clustering architecture and features
- Prerequisites and supported workloads
- Cluster-aware updating and storage solutions
- Lab: Explore HA features and validate prerequisites in Windows Server 2019
3
Module 3 – SQL Server HA Features Overview
- Failover Cluster Instances (FCI)
- Availability Groups (AG)
- Log Shipping: capabilities and limitations
- Lab: Compare and configure three HA methods in test environments
4
Module 4 – Windows Server Failover Clustering (WSFC)
- WSFC installation and configuration
- Quorum models and witness types
- Storage configuration and validation
- Maintenance, patching, and upgrading strategies
- Adding and removing cluster nodes
- Cluster monitoring and logging
- Lab: Build a two-node Windows Server cluster and test failover
5
Module 5 – SQL Server Failover Cluster Instances (FCI)
- FCI architecture and installation
- Active/Active and Active/Passive deployments
- MS DTC integration
- SQL Server FCI patching and upgrades
- Monitoring and troubleshooting FCI
- Lab: Deploy a SQL Server FCI and validate failover and recovery procedures
6
Module 6 – SQL Server Availability Groups (AG)
- Configuring AGs (synchronous/asynchronous)
- Read-only routing and load balancing
- Direct seeding and distributed availability groups
- Adding/removing databases and files from AGs
- AG backup and restore strategies
- Patching and rolling upgrades
- Monitoring and troubleshooting AG
- Lab: Create and manage an Always On Availability Group with multiple replicas
7
Module 7 – SQL Server Interoperability with Other Services
- HA integration with SQL Server Integration Services (SSIS)
- Considerations for Analysis Services (SSAS) and Reporting Services (SSRS)
- Licensing and supportability in HA deployments
- Lab: Deploy Reporting Services in a clustered environment
Informations
Durée
3 jour(s)
21h
Tarif
Sur demande
Formations similaires
Autre
Module 11 : Techniques élémentaires de méthodes d’apprentissage
2 jour(s)
Sur demande
Autre
Accueil - Maîtrise des Incivilités et Prévention de l'Agressivité en Milieu Hospitalier - SAU de Cochin - Port Royal
2 jour(s)
Sur demande
Autre
Administering Microsoft SQL Server
5 jour(s)
Sur demande
Autre
Administering Windows Server Hybrid Core Infrastructure (AZ-800)
4 jour(s)
Sur demande