Target Audience: This course provides students with the knowledge and skills to design high availability database solutions using Microsoft SQL Server 2005. It is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment.

Pre-requisites: Before attending this course, students must have the following pre-requisites:

• Be familiar with SQL Server 2005 features, tools, and technologies.
• Knowledge of the operating system and platform.
• Monitoring and troubleshooting skills.
• Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential - or equivalent experience.
• In addition, it is recommended, but not required, that students have completed: Course 2778, Writing Queries Using Microsoft SQL Server 2005 Transact-SQL; Course 2779, Implementing a Microsoft SQL Server 2005 Database; Course 2780, Maintaining a Microsoft SQL Server 2005 Database.

Purpose: After completing this course, students will be able to identify business requirements and technical and non-technical constraints of high-availability; design a SQL Server cluster implementation; determine the storage requirements for SQL Server databases; design a log shipping solution; design a database mirroring solution; design a highly-available solution based on replication; design high-availability solutions by combining existing high-availability technologies; document and test high-availability solutions.NB. This is a preliminary course syllabus. Some parts of the course are currently in development, so some elements of this syllabus are subject to change.