Login:  Password:    
forgot my password
sign up!
Search: 

Menu

Home

How it works?

Buy this course

Discuss! Add a comment
Add this course to my favorites
Add a personal note
RSS Feeds

Course's author:

Ruy Bentes Pimentel Neto

Ruy Bentes Pimentel Neto (ruy.pimentel@gmail.com) is a Senior Database Administrator, Dell Computers Employee, Hold MCDBA, MCSE+I Certifications. Experience of 10 years in Networking, Operational Systems and Database Administration.
Go to author's Space

Course stats:

Favorited:  0 times
 
no vote received

Features

Textual content

Video tutorial

Exercise

Source code

Downloads

Recommended post



 
  Content  
  Notes  
  Discuss  

Online course
Course Failover Clustering

In this Failover Clustering Training Course we will create a cluster with Sql Server 2008 R2 in a virtual machine without needing a rugged hardware. We'll see how this cluster would act in a real environment.



Introduction
 Vídeo
1)  Introduction
Description: In this first lesson we will start by explaining the technology and informing the hardware and software requirements.  |
[Mark this item as viewed]


 Vídeo
2)  Downloads
Description: In this lesson we are going to download windows storage server 2008, windows server 2008 R2 and Sql Server 2008 R2. |
[Mark this item as viewed]


 Vídeo
3)  Domain Controller
Description: After our first VM have been created, we are going to start the windows server 2008 installation, once we are done with the O.S. we will configure the network adapters and disable the firewall service, which is not necessary in our environment, after this we are going to begin the steps to build our domain controller by using add server roles wizard to add the Active Directory Domain Service.  |
[Mark this item as viewed]


 Vídeo
4)  Storage Server Installation
Description: With our Domain Controller set we will build our second virtual machine |
[Mark this item as viewed]


 Vídeo
5)  ISCSI Target Installation
Description: Now that windows storage server 2008 have been installed, the next step is to perform the installation of iSCSI Target software |
[Mark this item as viewed]


 Vídeo
6)  Nodes Operating System Installation
Description: Now that we have setup our domain controller and storage server, we are going to begin the nodes operating system installation and configuration |
[Mark this item as viewed]



Shared Disks
 Vídeo
7)  Adding Shared Disks
Description: With our both nodes almost ready we need to add the shared disks to them, for we be able to do this, is necessary to use the iSCSI Initiator tool |
[Mark this item as viewed]


 Vídeo
8)  Installing MSCS
Description: Now that we have our shared disks in place we are going to install Microsoft Cluster Service – MSCS |
[Mark this item as viewed]



Sql Server
 Vídeo
9)  Install Sql Server in the cluster on a nod
Description: Now we will start the Sql Server installation on a node, with the cluster service set, we just need to put the sql server media in the node that will be installed and run the setup, then go to installation menu and choose the New Sql Server Failover Cluster option |
[Mark this item as viewed]


 Vídeo
10)  Failover cluster manager
Description: Continue the Installation of Sql Server on the first node |
[Mark this item as viewed]


 Vídeo
11)  Add a second node to Sql Server Cluster
Description: We will start the Sql Server installation on the second node, with the cluster service set, we just need to put the sql server media in the node that will be installed and run the setup |
[Mark this item as viewed]



SQL Server Integration Service (SSIS)
 Vídeo
12)  MSDTC Clustering
Description: Now that we have clustered Sql Server, it’s time to cluster others components that Sql Server use, starting by clustering MSDTC (Microsoft Distributed Transaction Coordinator) which is used for some replication configurations |
[Mark this item as viewed]


 Vídeo
13)  XML configuration file
Description: Continue SSIS (Sql Server Integration Service) clustering now we need to change some registry keys and configure the SSIS xml configuration file |
[Mark this item as viewed]


 Vídeo
14)  Testing Cluster
Description: Now that we have configured and cluster Sql Server and the other dependents components, it’s time to test our environment.  |
[Mark this item as viewed]


 Vídeo
15)  DISKPART
Description: Now we are going to setup a new cluster environment using command line tools, this is important because using this we can automate the entire cluster installation.  |
[Mark this item as viewed]


 Vídeo
16)  Configure in-memory Session Replication
Description: Continuing our new cluster setup using command line tools, we finish the disks configurations using DISKPART utility.  |
[Mark this item as viewed]


 Vídeo
17)  Set up clustering in a MAN
Description: Course FailoverClustering - Lesson 17 |
[Mark this item as viewed]


 Vídeo
18)  Set up clustering in a WAN
Description: Course FailoverClustering - Lesson 18 |
[Mark this item as viewed]


 Vídeo
19)  Geographic mirroring
Description: Course FailoverClustering - Lesson 19 |
[Mark this item as viewed]



Creating disk pools
 Vídeo
20)  Part 1
Description: Course FailoverClustering - Lesson 20 |
[Mark this item as viewed]


 Vídeo
21)  Part 2
Description: Course FailoverClustering - Lesson 21 |
[Mark this item as viewed]


 Vídeo
22)  Part 3
Description: Course Failover Clustering - Lesson 22 |
[Mark this item as viewed]



Automating SQL Cluster Installation
 Vídeo
23)  Main PowerShell Script - Part 1
Description: In this lesson, we will proceed with our main PowerShell script, using this script we will add Sql server pre-install requirements and failover clustering role, also it will validate and build the cluster between the two nodes. |
[Mark this item as viewed]


 Vídeo
24)  Main PowerShell Script - Part 2
Description: In this lesson, we will proceed with our main PowerShell script, we are going to detect and fix some issues on the script to get it in the right way to run and build our cluster environment. |
[Mark this item as viewed]


 Vídeo
25)  SQL Server Install Script
Description: Now that we already ran out main script and build the cluster, we will create the SQL Server Installation script to build our first sql server node of the cluster.  |
[Mark this item as viewed]


 Vídeo
26)  Adding cluster node with scripts
Description: In this class you will learn to add a node to a Sql Cluster using unattended installation thru scripts.  |
[Mark this item as viewed]


 Vídeo
27)  Setup SQL Cluster
Description: In this class you will start to learn how to setup a SQL cluster using the advanced cluster preparation, this basically allows us to first install the nodes separately and only in the end join the cluster nodes.  |
[Mark this item as viewed]



Finalization
 Vídeo
28)  Nodes installation
Description: In this class you will continue to learn how to setup a Sql cluster using the advanced cluster preparation. |
[Mark this item as viewed]


 Vídeo
29)  Post install tests
Description: In this class you will to learn how to perform some post install test tasks to Sql cluster setup using the advanced cluster preparation.  |
[Mark this item as viewed]


 Vídeo
30)  Final Considerations
Description: In this class we will use the sql server configuration manager to setup the virtual ip address for we don’t need to specify the instance name, just the sql virtual name.  |
[Mark this item as viewed]



SQL Server 2008 Maintenance plan
 Vídeo
31)  Database maintenance
Description: This lesson will show what is a database maintenance plan and how can you configure a good SQL Server maintenance plan. |
[Mark this item as viewed]


 Vídeo
32)  Maintenance Cleanup Task
Description: This lesson will show what is a database maintenance plan and how can you configure Maintenance Cleanup Task. |
[Mark this item as viewed]


 Vídeo
33)  Database Email & Operator Alert
Description: This lesson will show what is a database maintenance plan and how can you configure Database Email & Operator Alert. |
[Mark this item as viewed]










mrbool.com
contact us   |   publish your post   |   buy credits

Copyright 2013 - all rights reserved to www.web-03.net