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