Enable-​Sql​Always​On

Enables the AlwaysOn availability groups feature.

Syntax

Enable-SqlAlwaysOn
      [[-Path] <String>]
      [-NoServiceRestart]
      [-Force]
      [-Credential <PSCredential>]
      [-InformationAction <ActionPreference>]
      [-InformationVariable <String>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]
Enable-SqlAlwaysOn
      [-InputObject] <Server>
      [-NoServiceRestart]
      [-Force]
      [-Credential <PSCredential>]
      [-InformationAction <ActionPreference>]
      [-InformationVariable <String>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]
Enable-SqlAlwaysOn
      [-NoServiceRestart]
      [-Force]
      [-Credential <PSCredential>]
      [-InformationAction <ActionPreference>]
      [-InformationVariable <String>]
      [-WhatIf]
      [-Confirm]
      -ServerInstance <String>
      [<CommonParameters>]

Description

The Enable-SqlAlwaysOn cmdlet enables AlwaysOn on an instance of SQL Server. If the AlwaysOn availability groups feature is enabled while the SQL Server service is running, the database engine service must be restarted for the changes to complete. Unless you specify the Force parameter, the cmdlet prompts you to restart the service.

If the AlwaysOn availability groups feature is already enabled, no action is performed.

This cmdlet can run against a remote service.

You must have Administrator permissions to execute this cmdlet.

Examples

Example 1: Enable AlwaysOn availability groups at the specified path

PS C:\> Enable-SqlAlwaysOn -Path "SQLSERVER:\Sql\Computer\Instance"

This command enables AlwaysOn availability groups on the instance of SQL Server located at the specified path. This change requires restarting the instance, and you will be prompted to confirm this restart.

Example 2: Enable AlwaysOn availability groups at the specified path and restart the server without confirmation

PS C:\> Enable-SqlAlwaysOn -Path "SQLSERVER:\Sql\Computer\Instance" -Force

This command enables AlwaysOn availability groups on the instance of SQL Server located at the specified path. The Force option causes the server instance to be restarted without prompting you for confirmation.

Example 3: Enable AlwaysOn availability groups for the specified server instance

PS C:\> Enable-SqlAlwaysOn -ServerInstance "Computer\Instance"

This command enables AlwaysOn availability groups on the instance of SQL Server named Computer\Instance. This change requires restarting the instance and you will be prompted to confirm this restart.

Example 4: Enable AlwaysOn availability groups for the specified server instance using Windows authentication

PS C:\> Enable-SqlAlwaysOn -ServerInstance "Computer\Instance" -Credential (Get-Credential "DOMAIN\Username")

This command enables AlwaysOn availability groups on the instance of SQL Server named Computer\Instance using Windows authentication. You will be prompted to enter the password for the specified account. This change requires restarting the instance, and you will also be prompted to confirm this restart.

Example 5: Enable AlwaysOn availability groups at the specified path without restarting the server

PS C:\> Enable-SqlAlwaysOn -Path "SQLSERVER:\Sql\Computer\Instance" -NoServiceRestart

This command enables AlwaysOn availability groups on the SQL Server instance located at the specified path, but the command does not restart the instance. The change will not take effect until you manually restart this server instance.

Required Parameters

-InputObject

Specifies the server object of the SQL Server instance.

Type:Server
Position:1
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters:False
-ServerInstance

Specifies the name of the SQL Server instance. The format is MACHINENAME\INSTANCE. To enable this setting on a remote server, use this along with the Credential parameter.

Type:String
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

Optional Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False
-Credential

Specifies the name of the SQL Server instance on which to enable the AlwaysOn availability groups feature. The format is MACHINENAME\INSTANCE. To enable this setting on a remote server, use this along with the Credential parameter.

Type:PSCredential
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Force

Forces the command to run without asking for user confirmation. This parameter is provided to permit the construction of scripts.

Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-InformationAction

Specifies how this cmdlet responds to an information event.The acceptable values for this parameter are:- Continue

  • Ignore
  • Inquire
  • SilentlyContinue
  • Stop
  • Suspend
Type:ActionPreference
Aliases:infa
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-InformationVariable

Specifies an information variable.

Type:String
Aliases:iv
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-NoServiceRestart

Indicates that the user is not prompted to restart the SQL Server service. You must manually restart the SQL Server service for changes to take effect. When this parameter is set, Force is ignored.

Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Path

Specifies the path to the SQL Server instance. This is an optional parameter. If not specified, the current working location is used.

Type:String
Position:1
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False