DSCResources/MSFT_xSQLDatabaseRecoveryModel/MSFT_xSQLDatabaseRecoveryModel.psm1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
$currentPath = Split-Path -Parent $MyInvocation.MyCommand.Path
Write-Verbose -Message "CurrentPath: $currentPath"

# Load Common Code
Import-Module $currentPath\..\..\xSQLServerHelper.psm1 -Verbose:$false -ErrorAction Stop

function Get-TargetResource
{
    [CmdletBinding()]
    [OutputType([System.Collections.Hashtable])]
    param
    (
        [parameter(Mandatory = $true)]
        [ValidateSet("Full","Simple","BulkLogged")]
        [System.String]
        $RecoveryModel = "Full",

        [parameter(Mandatory = $true)]
        [System.String]
        $SqlServerInstance,

        [parameter(Mandatory = $true)]
        [System.String]
        $DatabaseName
    )
    
    $SqlServerInstance = $SqlServerInstance.Replace('\MSSQLSERVER','')  
    New-VerboseMessage -Message "Checking Database $DatabaseName recovery mode for $RecoveryModel"

    $db = Get-SqlDatabase -ServerInstance $SqlServerInstance -Name $DatabaseName
    $value = ($db.RecoveryModel -eq $RecoveryModel)
    New-VerboseMessage -Message "Database $DatabaseName recovery mode comparison $value."
    
    $returnValue = @{
        RecoveryModel = $db.RecoveryModel
        SqlServerInstance = $SqlServerInstance
        DatabaseName = $DatabaseName
    }
    
    $returnValue
}


function Set-TargetResource
{
    [CmdletBinding()]
    param
    (
        [parameter(Mandatory = $true)]
        [ValidateSet("Full","Simple","BulkLogged")]
        [System.String]
        $RecoveryModel = "Full",

        [parameter(Mandatory = $true)]
        [System.String]
        $SqlServerInstance,

        [parameter(Mandatory = $true)]
        [System.String]
        $DatabaseName
    )  
 
    $SqlServerInstance = $SqlServerInstance.Replace('\MSSQLSERVER','')  
    $db = Get-SqlDatabase -ServerInstance $SqlServerInstance -Name $DatabaseName    
    New-VerboseMessage -Message "Database $DatabaseName recovery mode is $db.RecoveryModel."
    
    if($db.RecoveryModel -ne $RecoveryModel)
    {
        $db.RecoveryModel = $RecoveryModel;
        $db.Alter();
        New-VerboseMessage -Message "DB $DatabaseName recovery mode is changed to $RecoveryModel."
    }
    
    if(!(Test-TargetResource @PSBoundParameters))
    {
        throw New-TerminatingError -ErrorType TestFailedAfterSet -ErrorCategory InvalidResult
    }    
}


function Test-TargetResource
{
    [CmdletBinding()]
    [OutputType([System.Boolean])]
    param
    (
        [parameter(Mandatory = $true)]
        [ValidateSet("Full","Simple","BulkLogged")]
        [System.String]
        $RecoveryModel = "Full",

        [parameter(Mandatory = $true)]
        [System.String]
        $SqlServerInstance,

        [parameter(Mandatory = $true)]
        [System.String]
        $DatabaseName
    )   
    $SqlServerInstance = $SqlServerInstance.Replace('\MSSQLSERVER','')  
    $result = ((Get-TargetResource @PSBoundParameters).RecoveryModel -eq $RecoveryModel)
    
    $result
}


Export-ModuleMember -Function *-TargetResource