SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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

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

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


Prakash Heda works as Sr. Database Administrator at Advent Software. His expertise includes Performance Tuning/Troubleshooting, high availability, SAN configuration and windows administration. He has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash holds certifications for MCDBA and MCITP. His background includes administration & development using VB/ASP/SSIS using SQL Server 2000, 2005 and 2008/R2 and SQL server 2012. He is an active member of PASS, SQL Saturday. He’s a frequent presenter at user groups, SQL Saturdays, and other community events. He is also an avid tweeter, blogger and runner.


Leave a comment on the original post [www.sqlfeatures.com, opens in a new window]

Loading comments...