• Microsoft Gold Certified Partner
  • Cisco Partner Learning Associate
  • Better Business Bureau

Questions? Call us at (919) 336-1000

2788 Designing a High Availability Database Solutions Using Microsoft SQL Server 2005 - Details

Return to All courses

Description:

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

More Information  

Duration

3 days

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.

Prerequisites

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. Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience.

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

Please call Jon Kudlick, Director of Sales at (919) 336-1000, ext. 1025 or email sales@nhrtp.com for class information.

Contact us to learn more about our courses and certifications.

Return to Top

 
 

News and Events

View all news

Top Certifications

"75 percent of managers believe that certified individuals are more productive and that certifications are important to team performance." - MCP Customer Satisfaction Study

Top Certifications in Information Technology Today

Why get certified? The importance of certifications. Read more...

 

What sets us apart

New Horizons Integrated Learning

For training to have a lasting and measurable impact, New Horizons understands that course content has to be designed and delivered in the context of our client’s specific environment and business need.  To achieve this, we blend custom content with leading edge and time honored training approaches, including Traditional Instructor-Led, Mentored Learning, Online Live, and Online Anytime, to meet the specific learning style of the individual and the complex learning objectives of the organization.

New Horizons Integrated Learning guides learners through all stages of the learning lifecycle. It consists of five components - Assess, Learn, Reinforce, Support and Validate - to create the most effective learning experience available in the industry. 

Our Commitment, Guarantee and Promise