SQLPS Module
This section contains the help topics for the SQL Server PowerShell cmdlets.
SQLPS Cmdlets
| Cmdlet | Description |
|---|---|
| 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. |