Failover clustering is the most effective way to achieve high availability in a SQL Server environment. When you cluster any Windows servers, With Cluster service, if a failure occurs in a crucial hardware component or in the SQL Server service, then the drives, SQL Server, and associated services will fail over to the secondary server. The entire failover is automatic and generally takes between 30 and 60 seconds. With other SQL Server high-availability solutions such as log shipping or replication, someone has to manually change the roles to the secondary server if a disaster strikes the main server.

Learn how to implement and managing the sql server clusters boost your technical expertise for your success ladder as an exceptional SQL Server Database administrator.

Audience

This course is intended for IT Professionals who administer and maintain SQL Server cluster environment.

Course fee - 400$

For any queries on how to pay, mail us to billing@sqlservermasters.com

No prior experience is presumed.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture.

Software Needed on Each Student PC

  • Windows Server 2003 or 2008, Windows XP Professional, with at least 1GB RAM
  • SQL Server 2008

CLUSTERING

WINDOWS CLUSTERING

  • An overview of Windows Clustering Technologies
  • Server Cluster Architecture
  • Server Cluster concepts
  • Windows 2003 clustering setup (screenshots only)
  • Server Cluster Troubleshooting
  • Network Load balancing Architecture
  • Summary

SQL SERVER CLUSTERING

  • SQL Server clustering concepts
  • SQL Server Cluster Installation pre-requisites
  • Cluster Installation (Live and screenshot) - SQL 2005/SQL 2008
  • Post Installation Steps
  • Up-gradation from SQL 2000/2005 to SQL 2005/2008
  • Side-by-Side Migration (SQL 2000/2005 to SQL 2005/2008)
  • Un-installation of SQL Cluster (SQL 2000/SQL 2005/SQL 2008)
  • Installing Service Packs and Hot-fixes on SQL Cluster
  • SQL Cluster troubleshooting (Common issues, Root cause analysis)
  • Corporate awareness and importance

After completing this course, students will be able to:

  • Install and configure SQL Server 2008 cluster.
  • Fail over groups between nodes
  • Upgrading/migrating SQL clusters
  • Installing hot-fixes on SQL Clusters.
  • Troubleshooting and maintaining the SQL Cluster in environment.