Prepare Windows 7 to create Hyper-V Virtual lab to implement SQL Server 2008 R2 SP1 Active/Active Cluster

Share on:

This series of Videos will walk through how to prepare existing windows 7 machine to test and validate active/active node SQL server cluster configuration prior to production!!not only will try how to build a Hyper-V test lab to validate SQL clusters, I will also cover overall knowledge of dependent technologies to build SQL cluster to attain better troubleshooting skills by DBA (domain controller, storage controller, windows cluster configuration)!!

This video series on same track as Denali CTP1 though enhanced to have below points to make it more smooth and align with production configuration requirements!! ✱ Learn to create Windows 2008 R2 SP1 Hyper-V lab within windows 7 machine without affecting existing functionality (no need of a separate box to evaluate SQL features as needed in Denali video series) ✱ Using Parent and Child disks feature of Hyper-V to reduce space requirement and save installation time for new VHD’s ✱ Configure Hyper-V network configuration to work within 3 machines and accessible outside network ✱ Configuring ISCSI storage controller ✱ Configuring cluster with regular domain user privileges ✱ Slipstream Service pack 1 and CU updates SQL Server binaries to have one installation ✱ Configure MSTSC and firewall settings for SQL Cluster ✱ Configure required firewall ports on windows cluster

Complete set of Videos (SQL 2008 R2 SP1 2 Node Active-Active Cluster)

Part 11: Prepare W2k8 R2 VHD Hyper-V lab to boot from windows 7 Part 12: Prepare Hyper-V configuration/networking Part 13: Configure Windows 2008 R2 Domain Controller Part 14: Configure Windows 2008 R2 ISCSI Controller Part 15: Preparing nodes for failover cluster Part 16: Configure 2 node Windows 2008 R2 SP1 failover cluster Part 17: Install SQL Server failover cluster on Node 1 Part 18: Add SQL Server Node 2 to cluster Part 19: Configure Second SQL Installation for active/active

Download: Install-WindowsImage PowerShell Script Steps: Start powershell as administrator Execute: Set-ExecutionPolicy Unrestricted Execute: cd c:\sources Execute: .\Install-WindowsImage.ps1 -WIM C:\sources\install.wim -Apply -Index 3 -Destination X:

Download and install: EasyBCD 2.1

 

Part 11: Prepare W2k8 R2 VHD Hyper-V lab to boot from windows 7

Windows 7 to configure Windows 2008 R2 SP1 VHD
 

Part 12: Prepare Hyper-V configuration/networking

 

Upcoming!!.Part 13: Configure Windows 2008 R2 Domain Controller

Let me know how do you like this series and any specific questions you have My contact email: prakash@sqlfeatures.com"