Resource Type: dsc_sqlalwaysonservice

Defined in:

lib/puppet/type/dsc_sqlalwaysonservice.rb

Providers:

powershell

Overview

The DSC SqlAlwaysOnService resource type. Automatically generated from ‘SqlServerDsc/DSCResources/MSFT_SqlAlwaysOnService/MSFT_SqlAlwaysOnService.schema.mof’

To learn more about PowerShell Desired State Configuration, please visit technet.microsoft.com/en-us/library/dn249912.aspx.

For more information about built-in DSC Resources, please visit technet.microsoft.com/en-us/library/dn249921.aspx.

For more information about xDsc Resources, please visit github.com/PowerShell/DscResources.

Properties

• ensure

  The basic property that the resource should be in.

  Supported values:

  • exists?
  • present
  • absent

Parameters

• dsc_ensure

  Ensure - An enumerated value that describes if the SQL Server should have Always On high availability and disaster recovery (HADR) property enabled (‘Present’) or disabled (‘Absent’). Valid values are Present, Absent.

• dsc_instancename

  InstanceName - The name of the SQL instance to be configured.

• dsc_ishadrenabled

  IsHadrEnabled - Returns the status of AlwaysOn high availability and disaster recovery (HADR).

  Supported values:

  • true
  • false
• dsc_psdscrunascredential

  PsDscRunAsCredential

• dsc_restarttimeout

  RestartTimeout - The length of time, in seconds, to wait for the service to restart. Default is 120 seconds.

• dsc_servername

  ServerName - The hostname of the SQL Server to be configured.

• name (namevar)
• provider

  The specific backend to use for this ‘dsc_sqlalwaysonservice` resource. You will seldom need to specify this — Puppet will usually discover the appropriate provider for your platform.