New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents

2788 Designing a High Availability Database Solutions Using Microsoft SQL Server 2005 On-Site Training

This on-site training class is also available as Public Schedule Seminar.

The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization

Course Description/Agenda

The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization. Who Should Attend: This course 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.
Prerequisite(s) or equivalent knowledge:
2780 Maintaining a Microsoft SQL Server 2005 Database 2779 Implementing a Microsoft SQL Server 2005 Database 2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Outline:
Lesson 1: Selecting the Appropriate High-availability Solution
Identifying High-availability Requirements and Constraints Analyzing High-availability Requirements and Constraints Determining Appropriate High-availability Solutions
Lesson 2: Designing a Clustering Solution
Designing the Platform for Clustering Designing the SQL Server Cluster Implementation Designing Recovery Strategies and Test Plans for Database Clustering Migrating and Upgrading SQL Server Clusters Designing an Operations Plan for Clustering
Lesson 3: Designing a Highly Available Database Storage Solution
Determining Storage Requirements for SQL Server Databases Determining Storage Requirements for SQL Server Components and Files Designing Storage Solutions for SQL Server Databases Designing a Backup and Restore Strategy
Lesson 4: Designing a Log Shipping Solution
Introduction to Designing a Log Shipping Solution Designing Log Shipping Server Roles and Topology Designing a Log Shipping Upgrade Strategy Designing an Operations Plan for Log Shipping
Lesson 5: Designing a Database Mirroring Solution
Introduction to Designing a Database Mirroring Solution Designing Database Roles and Topology for Database Mirroring Converting High-availability Solutions to Database Mirroring Designing an Operations Plan for Database Mirroring
Lesson 6: Designing a Highly Available Solution Based on Replication
Introduction to Designing a Replication Solution Designing a Replication Solution Designing a Replication Upgrade Strategy Designing an Operations Plan for Replication
Lesson 7: Combining High-availability Technologies
Evaluating Weaknesses in Each High-availability Technology Maximizing Availability by Combining High-availability Technologies
Lesson 8: Documenting and Testing a High-availability Strategy
Documenting High-availability Solutions Creating a Test Plan for High-availability Solutions