Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [CmdletBinding()]
- param(
- [Parameter(Mandatory=$true)]
- [string]$DomainNetBIOSName,
- [Parameter(Mandatory=$true)]
- [string]$DomainAdminUser,
- [Parameter(Mandatory=$true)]
- [string]$DomainAdminPassword,
- [Parameter(Mandatory=$true)]
- [string]$WSFCNode1NetBIOSName
- )
- try {
- Start-Transcript -Path C:\cfn\log\Label-and-Format-drives.txt -Append
- $ErrorActionPreference = "Stop"
- $DomainAdminFullUser = $DomainNetBIOSName + '\' + $DomainAdminUser
- $DomainAdminSecurePassword = ConvertTo-SecureString $DomainAdminPassword -AsPlainText -Force
- $DomainAdminCreds = New-Object System.Management.Automation.PSCredential($DomainAdminFullUser, $DomainAdminSecurePassword)
- $LablenFormatPs={
- function ChangeDriveLabel([string]$driveletter,[string]$newlabel )
- {
- $disk = Get-WmiObject -Class win32_volume -Filter "DriveLetter = '$driveletter'"
- Set-WmiInstance -input $disk -Arguments @{ Label="DBLOG1"}
- }
- function FormatSQLDisk([string]$driveletter, [string]$drivelabel)
- {
- Format-Volume `
- -DriveLetter $driveletter `
- -NewFileSystemLabel $drivelabel `
- -FileSystem NTFS `
- -AllocationUnitSize 65536 –Force -Confirm:$false
- }
- $ErrorActionPreference = "Stop"
- #Label the disks
- ChangeDriveLabel -driveletter 'd:' -newlabel 'DBDATA'
- ChangeDriveLabel -driveletter 'e:' -newlabel 'DBLOG'
- ChangeDriveLabel -driveletter 'f:' -newlabel 'DBTEMPDB'
- #Format the disk
- FormatSQLDisk -driveletter 'D' -drivelabel 'DBDATA'
- FormatSQLDisk -driveletter 'E' -drivelabel 'DBLOG'
- FormatSQLDisk -driveletter 'F' -drivelabel 'DBTEMPDB'
- }
- $serverInstance = $WSFCNode1NetBIOSName
- Invoke-Command -Scriptblock $LablenFormatPs -ComputerName $WSFCNode1NetBIOSName -Credential $DomainAdminCreds
- }
- catch {
- $error[0]|format-list -force #print more detail reason for failure
- $_ | Write-AWSQuickStartException
- }
Add Comment
Please, Sign In to add comment