Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Overview/Description
SQL Server 2008 R2 provides several key features that improve the availability of servers and databases so that downtime for users is minimized. These solutions include database mirroring, log shipping, replication, and failover clusters. These reliability features help administrators maintain multiple sets of data that help ensure that critical systems remain accessible, and can be fully recovered in the event of a disaster. This course addresses how to configure database mirroring, log shipping, replication, and failover clusters to ensure that SQL Server 2008 R2 environments are available to users at all times by providing a high-availability and complete disaster-recovery solution. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.
Professionals typically pursuing a career as a Database Administrator; individuals who don't work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.
One to two years of experience using SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server