Skip to content

Latest commit

 

History

History
103 lines (79 loc) · 2.39 KB

SqlAlwaysOnServices.adoc

File metadata and controls

103 lines (79 loc) · 2.39 KB

DSC Resource 'SqlAlwaysOnServices'

SqlAlwaysOnServices enables or disables SQL Server Always On high availability and disaster recovery (Always On HADR) for a SQL Server instance.

Source

DSC Resource

Documentation
Requirements

  • Target machine must be running Windows Server 2012 or later.

  • Target machine must be running SQL Server Database Engine 2012 or later.

  • Target machine must be a member of a Windows Server Failover Cluster.

Table 1. Attributes of category 'SqlAlwaysOnServices'
Parameter Attribute DataType Description Allowed Values

InstanceName

Key

String

The name of the SQL Server instance to be configured.

Enure

Required

String

Determines whether the alias should be added (Present) or removed (Absent).

  • Present (default)

  • Absent

ServerName

String

The host name of the SQL Server to be configured.

Default value is the current computer name.

RestartTimeout

UInt32

The length of time, in seconds, to wait for the service to restart.

Default: 120

CompatibilityLevel

String

Specifies the version of the SQL Database Compatibility Level to use for the specified database.

  • Version80

  • Version90

  • Version100

  • Version110

  • Version120

  • Version130

  • Version140

  • Version150

IsHadrEnabled

Bool

Returns the status of AlwaysOn High Availability and Disaster Recovery (HADR).

  • True

  • False
Example
SqlAlwaysOnServices:
  ServerName: SQL1
  SqlInstanceName: MSSQLSERVER
  RestartTimeout: 120