Home About Us Services Training Resources Clients Contact
Training
Course Catalog
Corporate Training
Services

 

SQL Server High Availability

Course Level: Advanced

Duration: 18 Hours

Covers: SQL Server 2005, 2000

Benefits:

Prerequsites:

Course Outline:

Introduction to High Availability

  • High Availability – What is it? And How to get there?

  • Availability Matrix

  • Types of unavailability

  • Cost of Availability

  • Barriers to availability

Basic of Achieving High Availability

  • Data Center best Practices

    • Location

    • Security

    • Cabling, Power, Network, Communication Systems

    • Third Party Hosting

    • Service Level Agreements

  • Change Managements

  • System & Process Standardization

  • Documentation

Understanding Technology for SQL Server High Availability

  • Windows Clustering

  • Server Clusters

  • Network Load Balancing Clusters

  • SQL Server 2000 & 2005 High Availability Options

  • Failover Clustering

  • Log Shipping

  • Replication

  • Database Mirroring (Only in 2005)

  • Understanding the available options

Disk Configurations for High Availability

  • Disk Terminology Review

  • Capacity Planning

  • Type of Disk Subsystems

    • DAS

    • NAS

    • SAN

  • Choosing the right desk technology

  • Understanding RAID

  • Understanding how SQL Server interacts with Disk Subsystem

  • Type of Disks and File Systems in Windows

  • Database & Log File Placement and Protection

  • Database File Size

  • Example Configurations

Highly Available Windows Clusters

  • Choosing right Version of Windows and SQL Server

  • Disk Requirements

  • Server Clusters

    • Understanding

    • Planning

    • Implementing

    • Supporting

  • Network Load Balancing Clusters

    • Understanding

    • Planning

    • Implementing

    • Supporting

SQL Server Failover Clustering

  • Planning for Failover Clustering

    • Version of Windows and SQL Servers

    • Number of Instances supported

    • Name of Virtual Server

    • No of Nodes

    • Disks

    • IP Address, Ports & Network Configurations

    • Applications and Failover Clustering

    • Service Accounts

    • Memory Considerations

  • Analysis Services and Failover clustering

  • Implementing SQL Server Failover Cluster

    • Prerequisites

    • Installation Order

    • Installing on Virtual Server

    • Verify failover cluster installation

  • Administering Failover Cluster

  • Troubleshooting Failover cluster

  • Disaster Recovery Scenarios

Log Shipping

  • Uses of Log Shipping

  • Basic Considerations for Log Shipping

  • Log Shipping and Backups

  • Implementing Log Shipping

  • Creating a Custom Coded Log Shipping

Replication

  • Using Replication to make Database Available

  • Highly available replication architecture

  • Disaster Recovery with a replicated architecture

  • Log Shipping and Replication

Database Mirroring

  • Understanding Database Mirroring

  • Implementing database Mirroring

  • Recovering from a failure

Administrative Tasks for High Available SQL Server

  • Security

  • Maintenance

  • Changing Database Options

  • Memory Management

Monitoring Highly Available SQL Server

  • Monitoring Basics

  • Choosing Monitoring solution

  • Implementing Monitoring Solutions








     



 

Contact SQLSquare today!