SQLPS
Esta seção contém os tópicos de ajuda para os cmdlets do SQL Server PowerShell.
SQLPS
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. |