Course 5331: Configuring High Availability and Disaster Recovery for SAP on Microsoft SQL Server 2005

Introduction In this two-hour online course, you will learn how to configure high availability and disaster recovery in an SAP on SQL Server 2005 solution. Topics covered include configuring clustering, database mirroring, log-shipping, and utilizing data availability features of SQL Server 2005. These courses are for database administrators that are responsible for installing and maintaining SAP on SQL Server 2005.

Student prerequisites:

To get the most out of these courses, target audience should have:

• On-the-job experience implementing, managing, and supporting SQL Server 2005.
• Working knowledge of SQL Server 2000 or SQL Server 2005 features, tools, and technologies.
• Interest in deploying SAP systems on SQL Server 2005.
• A working knowledge of basic SAP architecture.

Objectives At the end of the course, students will be able to:

• Explain the fundamentals of high-availability.
• Configure clustering for SAP on SQL Server 2005.
• Configure database mirroring for SAP on SQL Server 2005.
• Configure log shipping for SAP on SQL Server 2005.
• Utilize SQL Server 2005 data availability features for SAP.

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information Course Information Configuring High Availability and Disaster Recovery for SAP on SQL Server 2005 Module Introduction Fundamentals of High Availability Lesson Introduction What Is High Availability? Types of High-Availability Solutions Identifying the Features of High-Availability Solutions Combining High-Availability Solutions Self Test Configure Clustering for SAP on SQL Server 2005 Lesson Introduction What Is Clustering? How Clustering Works Types of Cluster Configurations Configuring SQL Server 2005 for Clustering Self Test Configure Database Mirroring for SAP on SQL Server 2005 Lesson Introduction What Is Database Mirroring? How Database Mirroring Works Types of Database Mirroring Modes Configuring SAP Applications for Database Mirroring Configuring SQL Server 2005 for Database Mirroring Monitoring Database Mirroring Self Test Configure Log Shipping for SAP on SQL Server 2005 Lesson Introduction What Is Log Shipping? How Log Shipping Works Configuring SAP Applications for Log Shipping Configuring SQL Server 2005 for Log Shipping Performing a Manual Failover in Log Shipping Self Test Utilize SQL Server 2005 Data Availability for SAP Lesson Introduction Data Availability Features of SQL Server 2005 Disaster Recovery Options Best Practices for Creating an Effective Backup Strategy Self Test Lab: Configuring High Availability and Disaster Recovery for SAP on SQL Server 2005 Lesson Introduction Scenario Exercise Information Lab Review Module Summary Glossary Module Introduction 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