Resource Type: dsc_sqldatabase

Defined in:

lib/puppet/type/dsc_sqldatabase.rb

Overview

The DSC SqlDatabase resource type. Automatically generated from version 16.6.0

Properties

• dsc_collation

  The name of the collation to use for the new database. Default value is the collation used by the server.

• dsc_compatibilitylevel

  Specifies the version of the _SQL Database Compatibility Level_ to use for the specified database.

• dsc_ensure

  When set to ‘’Present’‘, the database will be created. When set to `’Absent’‘, the database will be dropped. Default value is `’Present’‘.

• dsc_ownername

  Specifies the name of the login that should be the owner of the database.

• dsc_recoverymodel

  The recovery model for the specified database.

• dsc_servername

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

Parameters

• dsc_instancename (namevar)

  The name of the _SQL Server_ instance to be configured.

• dsc_name (namevar)

  The name of the _SQL Server_ database.

• 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).