Course 10158: Implementing High Availability and Replication in Microsoft SQL Server 2008

Introduction This two-hour course provides you with the skills and knowledge required to understand the different high-availability and replication technologies, which you can use to provide a robust SQL Server 2008 infrastructure and distribute data across the enterprise. You will learn how to implement high-availability solutions at the database level by using database mirroring and transaction log shipping.

Topics covered in this course include:

• Introduction to High Availability
• Implementing Server Clustering
• Implementing Database Mirroring
• Introducing Log Shipping
• Introducing Replication
• Types of Replication

Student prerequisites:

To benefit from this course, the learner must be familiar with using Microsoft Windows. They must have knowledge of basic relational database concepts and querying data by using Transact-SQL. They must be familiar with the role of a database administrator.
Objectives At the end of the course, students will be able to:

• Describe high availability.
• Implement server clustering.
• Implement database mirroring.
• Implement log shipping.
• Describe replication.
• Describe types of replication scenarios.

Modules & Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Implementing High Availability and Replication in Microsoft SQL Server 2008 Module Overview Introduction to High Availability Introduction Factors That Affect Availability Factors for Optimizing Database Availability Options for High-Availability Solutions Self Test Implementing Server Clustering Introduction What Is Server Clustering? Considerations for Server Clustering Installing SQL Server 2008 in a Cluster Self Test Implementing Database Mirroring Introduction Introducing Database Mirroring Exploring Different Configurations of Database Mirroring Preparing a Server for Database Mirroring Creating Database Mirroring Endpoints Create a Database Mirror Testing Database Mirroring Failover Self Test Introducing Log Shipping Introduction Log Shipping Configuring Log Shipping Managing Log Shipping Failover Implementing Log Shipping Self Test Introducing Replication Introduction Understanding Replication Benefits of Replication Server Roles in Replication Describing Articles, Publications, and Subscriptions Describing Replication Agents Self Test Types of Replication Introduction Snapshot Replication Transactional Replication Merge Replication HTTP Merge Replication Peer-to-Peer Replication Configure Snapshot Replication Self Test Best Practices Best Practices Lab: Implementing High Availability and Replication in Microsoft SQL Server 2008 Lab Overview Scenario Exercise Information Launch the Lab Lab Review Module Summary Module Summary Glossary Glossary System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled