http://www.sqlservercentral.com/blogs/sqlfeatures/2011/08/24/prepare-windows-7-to-create-hyper-v-virtual-lab-to-implement-sql-server-2008-r2-sp1-activeactive-cluster/

Printed 2014/10/01 10:10PM

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

2011/08/24

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

[adsenseyu5]

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


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.