SQL Server Installation on S2D: Step by Step
This video demonstrates how S2D can be created in your lab environment and how you can enable S2D and install SQL Server on a Windows Cluster.
======================================================
1. Create two VirtualBox VM with 30 GB of storage:
WMNODE088
WMNODE099
2. Enable Hyper-V
3. Install Windows Server 2016
4. Disable Firewall
5. Set the network to use the DNS server.
6. Add both the VMs to Active directory ABC.com
======================================================
7. Enable Hyper-V in VirtualBoxes
Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Hyper-V -All -NoRestart
8. Install Windows features
Install-WindowsFeature -Name "Hyper-V", "Failover-Clustering", "Data-Center-Bridging", "RSAT-Clustering-PowerShell", "Hyper-V-PowerShell", "FS-FileServer"
9. Check the storage
Fill in these variables with your values
$ServerList = "localhost"
Invoke-Command ($ServerList) {
Update-StorageProviderCache
Get-StoragePool | ? IsPrimordial -eq $false | Set-StoragePool -IsReadOnly:$false -ErrorAction SilentlyContinue
Get-StoragePool | ? IsPrimordial -eq $false | Get-VirtualDisk | Remove-VirtualDisk -Confirm:$false -ErrorAction SilentlyContinue
Get-StoragePool | ? IsPrimordial -eq $false | Remove-StoragePool -Confirm:$false -ErrorAction SilentlyContinue
Get-PhysicalDisk | Reset-PhysicalDisk -ErrorAction SilentlyContinue
Get-Disk | ? Number -ne $null | ? IsBoot -ne $true | ? IsSystem -ne $true | ? PartitionStyle -ne RAW | % {
$_ | Set-Disk -isoffline:$false
$_ | Set-Disk -isreadonly:$false
$_ | Clear-Disk -RemoveData -RemoveOEM -Confirm:$false
$_ | Set-Disk -isreadonly:$true
$_ | Set-Disk -isoffline:$true
}
Get-Disk | Where Number -Ne $Null | Where IsBoot -Ne $True | Where IsSystem -Ne $True | Where PartitionStyle -Eq RAW | Group -NoElement -Property FriendlyName
} | Sort -Property PsComputerName, Count
======================================================
10. Validate Cluster
Test-Cluster –Node "WMNODE98", "WMNODE99" –Include "Storage Spaces Direct", "Inventory", "Network", "System Configuration"
11. Create cluster
New-Cluster –Name WMCLUSTEST –Node WMNODE98, WMNODE99 -StaticAddress 10.80.3.101 –NoStorage
12. Install cluster administration tools
13. Enable Storage spaces direct
Enable-ClusterStorageSpacesDirect –CimSession WMCLUSTEST
14. Create a Volume
New-Volume -FriendlyName "DataDisk" -FileSystem CSVFS_ReFS -StoragePoolFriendlyName S2D* -Size 5GB
15. Enable Quorum in cluster using a shared location
16. Validate cluster again
Test-Cluster –Node "WMNODE98", "WMNODE99" –Include "Storage Spaces Direct", "Inventory", "Network", "System Configuration"
17. Install SQL server on the same volume.
18. Add node to SQL Server cluster
======================================================
DISCLAIMER:
This video is for learning purpose only. This demo is not to show the disk performance or best practices. This is a long road and there are so many concepts, this is just a basic demo so that you can create S2D in your laptop or desktop and learn.
Watch video SQL Server Installation on S2D: Step by Step online without registration, duration hours minute second in high quality. This video was added by user Coding Studio 03 June 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 932 once and liked it 9 people.