S​QL​PS

This section contains the help topics for the SQL Server PowerShell cmdlets.

sqlps

Add-​Sql​Availability​Database

Adds primary databases to an availability group or joins secondary databases to an availability group.

Add-​Sql​Availability​Group​Listener​Static​Ip

Adds a static IP address to an availability group listener.

Backup-​Sql​Database

Backs up SQL Server database objects.

Convert-​Urn​To​Path

Converts a SQL Server Management Object URN to a Windows PowerShell provider path.

Decode-​Sql​Name

Decodes an encoded SQL Server identifier name.

Disable-​Sql​Always​On

Disables the AlwaysOn availability groups feature for a server.

Enable-​Sql​Always​On

Enables the AlwaysOn availability groups feature.

Encode-​Sql​Name

Encodes special characters in SQL Server names to characters that can be used in PowerShell paths.

Invoke-​Policy​Evaluation

Invokes one or more SQL Server policy-based management policy evaluations.

Invoke-​Sqlcmd

Runs a script containing statements supported by the SQL Server SQLCMD utility.

Join-​Sql​Availability​Group

Joins the local secondary replica to an availability group.

New-​Sql​Availability​Group

Creates an availability group.

New-​Sql​Availability​Group​Listener

Creates an availability group listener and attaches it to an availability group.

New-​Sql​Availability​Replica

Creates an availability replica.

New-​Sql​HA​DR​Endpoint

Creates a database mirroring endpoint on a SQL Server instance.

Remove-​Sql​Availability​Database

Removes an availability database from its availability group.

Remove-​Sql​Availability​Group

Removes an availability group.

Restore-​Sql​Database

Restores a database from a backup or transaction log records.

Resume-​Sql​Availability​Database

Resumes data movement on an availability database.

Set-​Sql​Availability​Group

Sets settings on an availability group.

Set-​Sql​Availability​Group​Listener

Sets the port setting on an availability group listener.

Set-​Sql​Availability​Replica

Sets the settings on an availability replica.

Set-​Sql​HA​DR​Endpoint

Sets the properties of a database mirroring endpoint.

Suspend-​Sql​Availability​Database

Suspends data movement on an availability database.

Switch-​Sql​Availability​Group

Starts a failover of an availability group to a secondary replica.

Test-​Sql​Availability​Group

Evaluates the health of an availability group.

Test-​Sql​Availability​Replica

Evaluates the health of availability replicas.

Test-​Sql​Database​Replica​State

Evaluates the health of an availability database.