DSCResources/MSFT_SPDatabaseAAG/MSFT_SPDatabaseAAG.psm1
|
function Get-TargetResource { [CmdletBinding()] [OutputType([System.Collections.Hashtable])] param ( [Parameter(Mandatory = $true)] [System.String] $DatabaseName, [Parameter(Mandatory = $true)] [System.String] $AGName, [Parameter()] [System.String] $FileShare, [Parameter()] [ValidateSet("Present", "Absent")] [System.String] $Ensure = "Present", [Parameter()] [System.Management.Automation.PSCredential] $InstallAccount ) Write-Verbose -Message "Getting AAG configuration for $DatabaseName" # Check if the April 2014 CU has been installed. The cmdlets have been added in this CU if ((Get-SPDscInstalledProductVersion).FileMajorPart -eq 15 ` -and (Get-SPDscInstalledProductVersion).FileBuildPart -lt 4605) { $message = ("Adding databases to SQL Always-On Availability Groups " + ` "require the SharePoint 2013 April 2014 CU to be installed. " + ` "http://support.microsoft.com/kb/2880551") Add-SPDscEvent -Message $message ` -EntryType 'Error' ` -EventID 100 ` -Source $MyInvocation.MyCommand.Source throw $message } if ($Ensure -eq "Present") { Write-Verbose -Message "Database(s) must be included in AAG $AGName" $result = Invoke-SPDscCommand -Credential $InstallAccount ` -Arguments ($PSBoundParameters) ` -ScriptBlock { $params = $args[0] $Ensure = "Present" $databases = Get-SPDatabase | Where-Object -FilterScript { $_.Name -like $params.DatabaseName } $dbname = $params.DatabaseName if ($null -ne $databases) { foreach ($database in $databases) { $ag = $database.AvailabilityGroup if ($null -ne $ag) { if ($ag.Name -ne $params.AGName) { $Ensure = "Absent" } } else { $Ensure = "Absent" } } } else { Write-Verbose -Message "Specified database(s) not found." $dbname = "" } return @{ DatabaseName = $dbname AGName = $params.AGName FileShare = $params.FileShare Ensure = $Ensure } } } else { Write-Verbose -Message "Database(s) must not be included in an AAG $AGName" $result = Invoke-SPDscCommand -Credential $InstallAccount ` -Arguments $PSBoundParameters ` -ScriptBlock { $params = $args[0] $Ensure = "Absent" $databases = Get-SPDatabase | Where-Object -FilterScript { $_.Name -like $params.DatabaseName } $dbname = $params.DatabaseName if ($null -ne $databases) { foreach ($database in $databases) { $ag = $database.AvailabilityGroup if ($null -ne $ag) { $Ensure = "Present" } } } else { Write-Verbose -Message "Specified database(s) not found." $dbname = "" } return @{ DatabaseName = $dbname AGName = $params.AGName FileShare = $params.FileShare Ensure = $Ensure } } } return $result } function Set-TargetResource { [CmdletBinding()] param ( [Parameter(Mandatory = $true)] [System.String] $DatabaseName, [Parameter(Mandatory = $true)] [System.String] $AGName, [Parameter()] [System.String] $FileShare, [Parameter()] [ValidateSet("Present", "Absent")] [System.String] $Ensure = "Present", [Parameter()] [System.Management.Automation.PSCredential] $InstallAccount ) Write-Verbose -Message "Setting AAG configuration for $DatabaseName" # Check if the April 2014 CU has been installed. The cmdlets have been added in this CU if ((Get-SPDscInstalledProductVersion).FileMajorPart -eq 15 ` -and (Get-SPDscInstalledProductVersion).FileBuildPart -lt 4605) { $message = ("Adding databases to SQL Always-On Availability Groups " + ` "require the SharePoint 2013 April 2014 CU to be installed. " + ` "http://support.microsoft.com/kb/2880551") Add-SPDscEvent -Message $message ` -EntryType 'Error' ` -EventID 100 ` -Source $MyInvocation.MyCommand.Source throw $message } if ($Ensure -eq "Present") { Write-Verbose -Message "Checking AAG settings for $DatabaseName" Invoke-SPDscCommand -Credential $InstallAccount ` -Arguments @($PSBoundParameters, $MyInvocation.MyCommand.Source) ` -ScriptBlock { $params = $args[0] $eventSource = $args[1] $databases = Get-SPDatabase | Where-Object -FilterScript { $_.Name -like $params.DatabaseName } if ($null -ne $databases) { foreach ($database in $databases) { $ag = $database.AvailabilityGroup if ($null -ne $ag) { if ($ag.Name -ne $params.AGName) { # Remove it from the current AAG first Remove-DatabaseFromAvailabilityGroup -AGName $params.AGName ` -DatabaseName $database.Name ` -Force # Now add it to the AAG it's meant to be in $addParams = @{ AGName = $params.AGName DatabaseName = $database.Name } if ($params.ContainsKey("FileShare")) { $addParams.Add("FileShare", $params.FileShare) } Add-DatabaseToAvailabilityGroup @addParams } } else { Write-Verbose -Message "Adding $DatabaseName to $AGName" $cmdParams = @{ AGName = $params.AGName DatabaseName = $database.Name } if ($params.ContainsKey("FileShare")) { $cmdParams.Add("FileShare", $params.FileShare) } Add-DatabaseToAvailabilityGroup @cmdParams } } } else { $message = "Specified database(s) not found." Add-SPDscEvent -Message $message ` -EntryType 'Error' ` -EventID 100 ` -Source $eventSource throw $message } } } else { Write-Verbose -Message "Removing $DatabaseName from $AGName" Invoke-SPDscCommand -Credential $InstallAccount ` -Arguments @($PSBoundParameters, $MyInvocation.MyCommand.Source) ` -ScriptBlock { $params = $args[0] $eventSource = $args[1] $databases = Get-SPDatabase | Where-Object -FilterScript { $_.Name -like $params.DatabaseName } if ($null -ne $databases) { foreach ($database in $databases) { Remove-DatabaseFromAvailabilityGroup -AGName $params.AGName ` -DatabaseName $database.Name ` -Force } } else { $message = "Specified database(s) not found." Add-SPDscEvent -Message $message ` -EntryType 'Error' ` -EventID 100 ` -Source $eventSource throw $message } } } } function Test-TargetResource { [CmdletBinding()] [OutputType([System.Boolean])] param ( [Parameter(Mandatory = $true)] [System.String] $DatabaseName, [Parameter(Mandatory = $true)] [System.String] $AGName, [Parameter()] [System.String] $FileShare, [Parameter()] [ValidateSet("Present", "Absent")] [System.String] $Ensure = "Present", [Parameter()] [System.Management.Automation.PSCredential] $InstallAccount ) Write-Verbose -Message "Testing AAG configuration for $DatabaseName" $PSBoundParameters.Ensure = $Ensure $CurrentValues = Get-TargetResource @PSBoundParameters Write-Verbose -Message "Current Values: $(Convert-SPDscHashtableToString -Hashtable $CurrentValues)" Write-Verbose -Message "Target Values: $(Convert-SPDscHashtableToString -Hashtable $PSBoundParameters)" $result = Test-SPDscParameterState -CurrentValues $CurrentValues ` -Source $($MyInvocation.MyCommand.Source) ` -DesiredValues $PSBoundParameters ` -ValuesToCheck @("Ensure", "DatabaseName") Write-Verbose -Message "Test-TargetResource returned $result" return $result } |