MS50490
Advanced SQL Server 2008 R2: Implementing and Managing High Availability Database Server Deployments
This three-day instructor-led course provides students with the knowledge and skills to help manage their highly-available Microsoft SQL Server 2008 R2 database server deployment. The Microsoft SQL Server 2008 R2 High-availability features include: Failover Clustering, Database Mirroring, Peer-to-peer Replication, and Log Shipping. This course presents various demos and hands-on labs to ensure that the students understand the considerations for the various high-availability solutions available with Microsoft SQL Server 2008 R2. The students will especially benefit from the depth of the content covered in the course.
OBS! Denna kurs har dragits tillbaks av Microsoft och i nuläget har vi inga klara releasedatum framåt! Självklart är du välkommen att kontakta oss så vi snabbt kan återkoppla när vi får mer info själva!
This training can be paid by SA-Voucher
Audience:
This course is for experienced IT Professionals who work in an enterprise-level environment and require the skills to support and maintain a highly available Microsoft SQL Server 2008 R2 database servers.
Course outline:
Module 1: High Availability
This module provides an overview of High Availability (HA) concepts, explaining the common terms used in High-Availability, and the difference between High Availability and Disaster Recovery (DR). It also covers the common DR objectives such as Recovery Time Objective (RTO) and Recovery Point Objective (RPO). Finally, the module discusses various Microsoft SQL Server 2008 R2 High Availability features.
Module 2: Failover Clustering
This module explains how to plan, configure and manage a Microsoft SQL Server 2008 R2 Failover Cluster and describes the various scenarios for using Failover Clustering. The module also covers upgrade, patching, best practices, common issues, and performance for Failover Clustering. Finally, the module discusses Geographically Dispersed.
Module 3: Database Mirroring
This module explains the various Database Mirroring scenarios and provides guidance on implementing these scenarios. The module discusses configuration, administration, security, and performance of Database Mirroring sessions. Further the module discusses some real-world scenarios including upgrading and patching mirrored databases, managing failover of multiple mirrored databases, Database Mirroring best practices and troubleshooting common issues. Finally the module concludes with discussion on client connections and transparent redirection.
Module 4: Database Snapshot
This module explains how to manage Database Snapshots, and use Database Snapshot to obtain read-only access to mirrored databases.
Module 5: Log Shipping
This module explains how to implement a warm standby using Microsoft SQL Server 2008 R2 Log Shipping. The module further discusses typical scenarios for Log Shipping, administration and monitoring of Log Shipping, performance tuning a Log Shipping implementation, upgrading the log shipped databases and enabling the secondary servers for query processing.
Module 6: Peer-to-Peer Transactional Replication
This module explains how to setup Microsoft SQL Server 2008 R2 Peer-to-Peer Transactional Replication. The module includes discussions on Peer-to-Peer Transactional Replication as a High Availability solution, performance considerations for Peer-to-Peer Replication, backup and restore considerations for replicated databases, and using Replication Monitor to identify and diagnose issues.
Module 7: Comparing High-Availability Solutions
This module compares the various High Availability solutions, discusses some common scenarios for these High Availability solutions as well as combining the various High-Availability technologies.
Module 8: Improving High-Availability
This module explains how to improve the availability of Microsoft SQL Server 2008 R2 by decreasing the planned and unplanned downtime.
Module 9: Recovery Scenarios and High Availability
This module explains how to perform pro-active database maintenance to detect and repair database errors and corruptions.