Skip to content

Instantly share code, notes, and snippets.

@nirinium

nirinium/addsqldrives.ps1

Created March 8, 2019 12:54
Show Gist options
  • Save nirinium/acccc28ced9953e2fcc9ac96f37033fa to your computer and use it in GitHub Desktop.
Save nirinium/acccc28ced9953e2fcc9ac96f37033fa to your computer and use it in GitHub Desktop.
Download ZIP
PowerCLI Add SQL Drives to VM
Raw
addsqldrives.ps1
<#
20gb E: SQLBinaries
20gb F: SystemDB
10gb G: TempDBData
10gb H: TempDBData2
10gb I: TempDBData3
10gb J: TempDBData4
10gb K: TempDBLog
50gb L: SQLData
20gb M: SQLLog
10gb W: NonSQLData
#>
Connect-VIServer %HOSTNAME%.corp.%INSERTDOMAINHERE%.com
$VM = get-vm -name %VMHOSTNAME%
New-HardDisk -CapacityGB 50 -StorageFormat Thin -Controller "SCSI controller 0"
New-HardDisk -VM $VM -CapacityGB 250 -StorageFormat Thick -Controller "SCSI Controller 1"
New-HardDisk -VM $VM -CapacityGB 250 -StorageFormat Thin -Controller "SCSI Controller 1"
New-HardDisk -VM $VM -CapacityGB 250 -StorageFormat Thin -Controller "SCSI Controller 1"
New-HardDisk -VM $VM -CapacityGB 250 -StorageFormat Thin -Controller "SCSI Controller 1"
New-HardDisk -VM $VM -CapacityGB 50 -StorageFormat Thin -Controller "SCSI Controller 1"
New-HardDisk -VM $VM -CapacityGB 50 -StorageFormat Thin -Controller "SCSI Controller 1"
New-HardDisk -VM $VM -CapacityGB 50 -StorageFormat Thin -Controller "SCSI Controller 1"
New-HardDisk -VM $VM -CapacityGB 50 -StorageFormat Thin -Controller "SCSI Controller 1"
New-HardDisk -VM $VM -CapacityGB 50 -StorageFormat Thin -Controller "SCSI Controller 1"
New-HardDisk -VM $VM -CapacityGB 50 -StorageFormat Thin -Controller "SCSI Controller 1"
New-HardDisk -VM $VM -CapacityGB 50 -StorageFormat Thin -Controller "SCSI Controller 1"
New-HardDisk -VM $VM -CapacityGB 50 -StorageFormat Thin -Controller "SCSI Controller 1"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment