Resource Type: dsc_sqltraceflag

Defined in:

lib/puppet/type/dsc_sqltraceflag.rb

Overview

The DSC SqlTraceFlag resource type. Automatically generated from version 16.6.0

Properties

• dsc_clearalltraceflags

  Specifies that there should be no trace flags set on the instance.

• dsc_restartservice

  Forces a restart of the Database Engine service and dependent services after the desired state is set. Default values is $false.

• dsc_restarttimeout

  The time the resource waits while the sql server services are restarted. Defaults to 120 seconds

• dsc_servername

  The host name of the _SQL Server_ to be configured. Default value is the current computer name.

• dsc_traceflags

  An array of trace flags that startup options should have. This parameter will replace all the current trace flags with the specified trace flags.

• dsc_traceflagstoexclude

  An array of trace flags to be removed from the existing trace flags.

• dsc_traceflagstoinclude

  An array of trace flags to be added to the existing trace flags.

Parameters

• dsc_instancename (namevar)

  The name of the _SQL Server_ instance to be configured.

• dsc_psdscrunascredential
• dsc_timeout

  The maximum time in seconds to wait for the DSC resource to complete.

• name (namevar)

  Description of the purpose for this resource declaration.

• validation_mode (defaults to: property)

  Whether to check if the resource is in the desired state by property (default) or using Invoke-DscResource in Test mode (resource).