SQL Server 2008 Clustering on Windows 2008 Video

Leave a comment (4) Go to comments

This is the Complete Video Services for SQL Server 2008 Cluster on Windows 2008.In this video series, we will cover

  1. What is Clustering
  2. Hardware and Software Requirement for Clustering.
  3. Installing and Configuring VMWARE for building virtual environment
  4. Installing Windows 2008 clustered environment
  5. Installing SQL Server Active Passive (Cluster) on Windows 2008 clustered environment
  6. Adding a node to existing SQL Server cluster
  7. How to patch SQL Server Clustered Environment by applying SP1 on SQL Server 2008 cluster instance.
  8. What is SQL Server Active Active Clustering
  9. Installing SQL Server Active Active Clustering
  10. Installing Analysis Services (SSAS) on a clustered environment
  11. Installing / Configuring Integration Services (SSIS) on a clustered environment
  12. Remove a node from a running clustered instance
  13. Un installing SQL Server Cluster.

Note : These Videos are being recorded on a virtual environment (LAPTOP) using VMWARE workstation. By using this videos, you can test Clustering in your desktop / laptop too.

Basic Overview of Clustering

SQL Server 2008 Clustering Part 1A


In this video, we will understand a basics of clustering and sql server clustering.

SQL Server 2008 Clustering – Part 1B

In this video we will understand the hardware and software requirement for installing SQL Server Clustered Environment.

SQL Server 2008 Clustering – Part 2

This Video help us in understanding,

  • How to Setting up VMWare Machine/Hosts  for cluster setup. This is required because we are doing this on our test machine (LAPTOP)
  • Installing Windows Operating System in both virtual Cluster Nodes and Domain Controller (which is required because of domain environment)

SQL Server 2008 Clustering – Part 3

This Video will help us in setting up domain environment like

  • Renaming of Machines
  • Setting up IP Addresses for this test environment
  • Installing Active Directory on Domain Controller

SQL Server 2008 Clustering – Part 4A

In this video, we will understand

  • Setting up DNS Server
  • Setting up Users Account for cluster configuration
  • Joining Cluster Nodes in Domain Environment
  • Setting up Private IP’s for cluster Heartbeat

SQL Server 2008 Clustering – Part 4B

In this video, we will understand

  • Joining Cluster Nodes in Domain

SQL Server 2008 Clustering – Part 5A

In this video, we will understand

  • Copying Media from USB to Local Nodes for Installtion
  • Installing ISCSI Drive Software (Star Wind freeware)
  • Setting up ISCSI Drive
  • Setting up Cluster Shared Drive

SQL Server 2008 Clustering – Part 5B

In this video, we will understand

  • Setting up storage for cluster / Shared Drives (contd…)
  • Install Cluster Services on Cluster Nodes

SQL Server 2008 Clustering – Part 6A

In this video, we will understand

  • Setting up Windows Cluster Environment by adding nodes in Cluster
  • Validate Cluster Configuration
  • Setting up Windows Cluster

SQL Server 2008 Clustering – Part 6B

SQL Server 2008 Clustering – Part 7A

In this video, we will understand

  • Validate Cluster Configuration (Contd…)
  • Setting up Windows Cluster (Contd…)
  • Adding Applications Roles
  • Add Cluster Resources / Resource Groups
  • Configuring MSDTC
  • Installing SQL Server
  • SQL Server 2008 Clustering – Part 7B

    In this video, we will understand

    • Installing SQL Server (Contd….)
    • SQL Server Install, feature / Component Selection
    • Setting up Shared Storage for Databases

     

    SQL Server 2008 Clustering – Part 8

    In this video, we will understand

    • Finishing SQL Server Cluster on Single Node
    • Validating SQL Server Cluster Installtion
    • Adding Node 2 to Existing Cluster

    SQL Server 2008 Clustering – Part 9A

    In this video, we will understand

    • Finishing Adding Node 2 on Cluster
    • Checking SQL Server Cluster Config

    SQL Server 2008 Clustering – Part 9B

    In this video, we will understand

    • Active Passive Cluster Setup, verifying failover

    SQL Server 2008 Clustering – Part 10A

    In this video, we will understand

    • Installing Services Pack on Clustered Environment (SQL Server 2008 Service Pack 1)


    SQL Server 2008 Clustering – Part 10B

      In this video, we will understand

    • Finishing up Installing Service Pack (Node Specific)

    SQL Server 2008 Clustering – Part 11A

      In this video, we will understand

    • Finishing Service Pack Installation
    • Checking Current Active Node where SQL Services are running by query
    • Checking SQL Server Version, after SP1
    • End of Active Passive Clustering
    • Brief of Active Active SQL Cluster

    SQL Server 2008 Clustering – Part 11B

      In this video, we will understand

    • Install a new instance for Active Active Configuration

    SQL Server 2008 Clustering – Part 12

      In this video, we will understand

    • Checking Newly installed SQL in a New Resource Group
    • Adding Other node in 2nd SQL Instance

    SQL Server 2008 Clustering – Part 13A

      In this video, we will understand

    • Finishing SQL Server Instance installation
    • Installing Analysis Services on a Cluster

    SQL Server 2008 Clustering – Part 13B

      In this video, we will understand

    • Add another Drive for Analysis Services

    SQL Server 2008 Clustering – Part 14

      In this video, we will understand

    • Installing SSAS in Clustered server
    • Installing Node 2 in Analysis Services

    SQL Server 2008 Clustering – Part 15A

      In this video, we will understand

    • Finishing SSAS on Clustered environment
    • Install SSIS on Clustered Environment
    • Requirement for SSIS clustered environment like disk

    SQL Server 2008 Clustering – Part 15B

    • Install SSIS on Clustered Environment on NODE(Add Node 2 on SSIS cluster)

    SQL Server 2008 Clustering – Part 16

      In this video, we will understand

    • Uninstall Node from a Clustered Environment
    • Uninstall Cluster

    EOF - SQL Server 2008 Clustering on Windows 2008 Video, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
    Leave a comment

    4 Comments.

    1. Perfect. Good Job !!!

      Thank you for the great sessions

    2. HiMehesh,

      I am not able to see any videos, please help.

      Regards,
      Parveen

    3. i created three virtual machines they are clusterdc, node1 and node2 as you mentioned in the video. when i am pinging from clusterdc to node 2 is not pinging and node1 to node 2 is also not pinging.

      Can you please give me replay.

      i’m in the middle of clustering if you give replay as soon as possible then i will continue with the clustering in my laptop.

      Thanks & regard
      prabhaker

    4. great videos!!!
      thanks!!!

    Leave a Reply

    Your email address will not be published. Required fields are marked *


    *


    You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

    Notify me of followup comments via e-mail. You can also subscribe without commenting.