Clustering SQL Server 2008 R2 on a Windows 2008 R2 Failover Cluster

Clustering SQL Server 2008 R2 on a Windows 2008 R2 Failover Cluster

Click on the links next to the red icons

below to view the free movies.
Click here to setup a login account and view all of the movies.

** These Movies Have Sound
** The Flash Plug-in is Required

Introduction
	Introduction

Windows 2008 R2 Cluster Diagram Part 1

Windows 2008 R2 Cluster Diagram Part 2

SQL Server 2008 R2 Cluster Diagram

Windows Server 2008 R2 Clustering Requirements and Limitations

SQL 2008 R2 Cluster Edition Limitations

New Cluster Features with Windows 2008 R2

Warning About Using Less Expensive Cluster Hardware

Building a Two Node Failover Cluster
	Run Windows Update

Install the Cluster Feature on All Nodes

Configure the Public Network

Configure the Private Network

Adding Storage to Node A - iSCSI Example Part 1

Adding Storage to Node A - iSCSI Example Part 2

Adding Storage to Node B - iSCSI Example

Validate the Cluster

Create the Cluster

Configure Networks

Quorum Modes

Changing the Quorum Mode

Testing the Cluster

Creating a Clustered SQL Server 2008 R2 Instance
	Adding Storage to the Cluster Part 1

Adding Storage to the Cluster Part 2

Clustering the MSDTC

Create SQL Server Service Account

Installing SQL 2008 R2 Prerequisites

Installing SQL 2008 R2 on Node A Part 1

Installing SQL 2008 R2 on Node A Part 2

Installing SQL 2008 R2 on Node A Part 3

Installing SQL 2008 R2 on Node B

Managing a SQL Server 2008 R2 Failover Cluster
	Connecting to the SQL Server 2008 R2 Clustered Instance

Creating a Database on the SQL Server 2008 R2 Clustered Instance

Moving the Clustered SQL Server 2008 R2 Instance to Another Node

Taking the Clustered SQL Server 2008 R2 Instance Offline

Pausing or Resuming a Clustered Node

Stopping and Starting the Cluster Service

Setting the Preferred Owners and Failback

Viewing and Modifying Dependencies

Adding Storage to the SQL Server 2008 R2 Cluster

Modifying the Cluster
	Adding a Node to an Active SQL Server 2008 R2 Cluster Part 1

Adding a Node to an Active SQL Server 2008 R2 Cluster Part 2

Adding a Node to an Active SQL Server 2008 R2 Cluster Part 3

Removing a SQL Server 2008 R2 Node from a Failover Cluster

Managing a Windows Server 2008 R2 Failover Cluster With PowerShell
	Viewing Failover Cluster Cmdlets

Connecting to a Remote Cluster and Running Cmdlets

Getting Help for a Cmdlet

Cmdlet Examples

Read Only Mode

Troubleshooting Clustering in Windows 2008 R2
	Event Viewer and Events in Failover Cluster Management

Diagnostic Logging

Validating an Active Cluster

Cluster Logs

Performance Counters


STANDARD PLAN			Access To Every Tutorial 24 Hours 7 Days A Week Learn More or ORDER NOW See Sales Demo>>

PREMIUM PLAN			Access to Every Tutorial 24 Hours 7 Days A Week Access to the IPOD Ready Tutorial Market Place Offline and Online Access Practice Tests Flash Cards End of Movie Quizzes Learn More or ORDER NOW See Sales Demo>>

LMS (Learning Management System) PLAN			Access to Every Tutorial 24 Hours 7 Days A Week Access to the IPOD Ready Tutorial Market Place Offline and Online Access Practice Tests Flash Cards End of Movie Quizzes Access to the Administrator Control Panel Assign Homework to Users Assign Pre & Post Tests Track All Results Learn More or ORDER NOW See LMS Demo>>