Course Description
This comprehensive 5-day course equips database professionals with advanced skills to design, implement, and manage high availability and disaster recovery solutions for SQL Server. Participants will gain hands-on experience with AlwaysOn Availability Groups, Failover Cluster Instances, and various replication techniques to ensure continuous database operations and minimize downtime in critical business environments.
Learning Objectives
- Understand SQL Server high availability and disaster recovery concepts and architectures
- Implement and manage AlwaysOn Availability Groups for enhanced database availability
- Configure and maintain Failover Cluster Instances for SQL Server
- Design and implement effective backup and recovery strategies
- Master various replication techniques for data distribution and disaster recovery
Course Modules
Day 1: Introduction to SQL Server High Availability and Disaster Recovery
- HA/DR concepts and terminology
- SQL Server HA/DR feature overview
- Assessing business requirements for HA/DR
- Planning HA/DR architectures
Day 2: Implementing AlwaysOn Availability Groups
- AlwaysOn Availability Groups architecture
- Configuring and managing availability groups
- Implementing read-scale availability groups
- Monitoring and troubleshooting availability groups
Day 3: Failover Cluster Instances and Windows Server Failover Clustering
- Failover Clustering concepts and architecture
- Installing and configuring a Failover Cluster Instance
- Managing and maintaining FCIs
- Implementing multi-subnet clustering
Day 4: Backup and Recovery Strategies
- Designing effective backup strategies
- Implementing advanced backup techniques
- Point-in-time recovery and log shipping
- Database snapshots and recovery models
Day 5: Replication and Additional HA/DR Techniques
- SQL Server replication architecture and types
- Implementing transactional and merge replication
- Database mirroring and log shipping
- Combining HA/DR technologies for comprehensive solutions
Practical Wins for Participants
- Ability to design and implement robust HA/DR solutions for SQL Server environments
- Hands-on experience with configuring and managing AlwaysOn Availability Groups
- Proficiency in implementing and maintaining Failover Cluster Instances
- Skills to optimize backup and recovery strategies for minimal data loss and downtime
Credits: 5 credit per day
Course Mode: full-time
Provider: Blackbird Training Centre
