SQLPS Module

Description

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

SQLPS Cmdlets

Add-SqlAvailabilityDatabase

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

Add-SqlAvailabilityGroupListenerStaticIp

Adds a static IP address to an availability group listener.

Backup-SqlDatabase

Backs up SQL Server database objects.

Convert-UrnToPath

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

Decode-SqlName

Decodes an encoded SQL Server identifier name.

Disable-SqlAlwaysOn

Disables the AlwaysOn availability groups feature for a server.

Enable-SqlAlwaysOn

Enables the AlwaysOn availability groups feature.

Encode-SqlName

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

Invoke-PolicyEvaluation

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-SqlAvailabilityGroup

Joins the local secondary replica to an availability group.

New-SqlAvailabilityGroup

Creates an availability group.

New-SqlAvailabilityGroupListener

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

New-SqlAvailabilityReplica

Creates an availability replica.

New-SqlHADREndpoint

Creates a database mirroring endpoint on a SQL Server instance.

Remove-SqlAvailabilityDatabase

Removes an availability database from its availability group.

Remove-SqlAvailabilityGroup

Removes an availability group.

Restore-SqlDatabase

Restores a database from a backup or transaction log records.

Resume-SqlAvailabilityDatabase

Resumes data movement on an availability database.

Set-SqlAvailabilityGroup

Sets settings on an availability group.

Set-SqlAvailabilityGroupListener

Sets the port setting on an availability group listener.

Set-SqlAvailabilityReplica

Sets the settings on an availability replica.

Set-SqlHADREndpoint

Sets the properties of a database mirroring endpoint.

Suspend-SqlAvailabilityDatabase

Suspends data movement on an availability database.

Switch-SqlAvailabilityGroup

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

Test-SqlAvailabilityGroup

Evaluates the health of an availability group.

Test-SqlAvailabilityReplica

Evaluates the health of availability replicas.

Test-SqlDatabaseReplicaState

Evaluates the health of an availability database.