SQL Server 2008 Fail-over Clustering - Training by MindQ Systems

SQL Server 2008 Fail-over Clustering - Training by MindQ Systems

 

  • SQL Server 2008 Fail-over Clustering

    Sale Date Ended

    INR 5000
    Sold Out

Invite friends

Contact Us

Page Views : 1901

About The Event

SQL Server 2008 Fail-over Clustering

The event dates: July 2nd and 3rd 2011

Day 1:           10 to 5PM with 1PM to 2 PM as break 6 hours

Day 2:           10 to 4PM with 1PM to 2 PM as break 5 hours 

Failover Clustering/ High-Availability Basics

A Quick High Availability and Disaster Recovery

Understanding the SQL Server Availability Technologies

Backup and Restore

Windows Clustering

Log Shipping

Database Mirroring

Replication

Applications, Availability, and Failover Clustering

Client Connections and Clustered SQL Server–Based Applications

Comparing Failover Clustering to Other Availability Technologies

Database Mirroring vs. Failover Clustering

Log Shipping vs. Failover Clustering

Replication vs. Failover Clustering

 

Windows Clustering Technologies

Clustering Technologies

  • Server clusters
  • Network Load Balancing

Clustering Technologies Architecture

  • Basic Architecture for Server Clusters
  • Basic Architecture for Network Load Balancing Clusters

Scenarios for Server Clusters

Applications or Services on a Server Cluster

Scenarios for Network Load Balancing

Types of Servers or Services in Network Load Balancing Clusters

 

Server Cluster

Introduction to Server Clusters

Dependencies on Other Technologies

Types of Server Clusters

  • Single Quorum Device Cluster
  • Majority Node Set Cluster
  • Local Quorum Cluster 

 

How a Server Cluster Works

Server Cluster Architecture

Basic Elements of a Two-Node Cluster with Single Quorum

Resource Dependencies Configured Within Resource Groups

Cluster Service Component Diagrams and Descriptions

  • Database Manager (for the cluster configuration database)
  • Node Manager (working with Membership Manager)
  • Failover Manager
  • Global Update Manager
  • Checkpoint Manager
  • Log Manager (quorum logging)
  • Event Log Replication Manager 

  

Server Cluster Processes

How Nodes Form, Join, and Leave a Cluster

  • Forming a Cluster
  • Joining a Cluster
  • Leaving a Cluster

Heartbeats, Regroup Events, and Quorum Arbitration

How Clusters Keep Resource Groups Available

Resource Health Monitoring (Polling)

How a Resource Group Comes Online

How a Resource Group Goes Offline

How Failover Occurs

Resource Failure and Group Failure (Without Node Failure)

Node Failure or Loss of Communication between Nodes

How Failback Occurs

 

Configuring Windows 2003/2008 Server Cluster

Choosing a Version and Edition of Windows Server

Prerequisites for Windows Server 2003/2008

Installing Windows Server 2003/2008 Clustering

Installing the First Cluster Node

Cluster Administration Account

Cluster Name Object.

Cluster Networks

Cluster Validation

Installing the Second Node of Your Cluster

Verifying the Nodes with Cluster Administrator

Creating a new resource group using Cluster Administrator

Configuring Microsoft Distributed Transaction Coordinator

 

SQL Server 2008 Pricing and Licensing 

SQL Server 2008 Server PLUS CAL Licensing

  • Server License
  • Device CAL
  • User CAL

SQL SERVER 2008 Processor Licensing

  • Processor License

PASSIVE SERVERS / FAILOVER SUPPORT

  • Database mirroring
  • Failover clustering
  • Backup Log-Shipping.

 

Preparing to SQL Server 2008 Fail-Over Clustering

Prerequisites for SQL Server 2008

Clusterable SQL Server Components

Changes to Setup in SQL Server 2008

Mixing Local and Clustered Instances on Cluster Nodes

Technical Considerations for SQL Server 2008 Failover Clustering

Determining the Number of Instances and Nodes

Disk Considerations

Memory and Processor

Security Considerations

Clustered SQL Server Instance Names

Instance ID and Program File Location

 

Installing SQL Server 2008 Fail-Over Clustering

Pre-SQL Server Installation Tasks.

Configure SQL Server–Related Service Accounts and Service Account Security

Stop Unnecessary Processes or Services

Check for Pending Reboots

Install SQL Server Setup Support Files

SQL Server 2008 Setup

Install the First Node

Add Nodes to the Instance

Perform Post installation Tasks

Verify the Configuration

Remove Empty Cluster Disk Resource Groups

Set the Preferred Node Order for Failover

Configure a Static TCP/IP Port for the SQL Server Instance

 

 

Administering a SQL Server 2008 Failover Cluster

Install SQL Server Service Packs, Patches, and Hot fixes

Introducing Failover Cluster Management

Monitoring the Cluster Nodes

Adding a Node to the Failover Cluster

Evicting a Node

Destroying a Cluster- Using Failover Cluster Management

Clustered SQL Server Administration

Changing the Service Account or the Service Account Passwords

Changing the IP Address of a Failover Clustering Instance

Renaming a Failover Clustering Instance

Uninstalling a Failover Clustering Instance

Best Practices on Clustering 

Lunch & Snacks will be served on both days.

Venue Map