通过

Set-SqlHADREndpoint

模块:
SQLPS Module

Sets the properties of a database mirroring endpoint.

语法

ByPath （默认值） 

Set-SqlHADREndpoint
    [[-Path] <String>]
    [-Owner <String>]
    [-Certificate <String>]
    [-IpAddress <IPAddress>]
    [-AuthenticationOrder <EndpointAuthenticationOrder>]
    [-Encryption <EndpointEncryption>]
    [-EncryptionAlgorithm <EndpointEncryptionAlgorithm>]
    [-Port <Int32>]
    [-State <EndpointState>]
    [-Script]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

ByObject 

Set-SqlHADREndpoint
    [-InputObject] <Endpoint>
    [-Owner <String>]
    [-Certificate <String>]
    [-IpAddress <IPAddress>]
    [-AuthenticationOrder <EndpointAuthenticationOrder>]
    [-Encryption <EndpointEncryption>]
    [-EncryptionAlgorithm <EndpointEncryptionAlgorithm>]
    [-Port <Int32>]
    [-State <EndpointState>]
    [-Script]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

说明

The Set-SqlHADREndpoint cmdlet changes the properties of a database mirroring endpoint.

示例

Example 1: Set the port number of a database mirroring endpoint

PS C:\> Set-SqlHADREndpoint -Path "SQLSERVER:\Sql\Computer\Instance\Endpoints\MainDbmEndpoint" -Port 5050

This command sets the port number of the database mirroring endpoint named MainDbmEndpoint to 5050 on the server instance named Computer\Instance.

Example 2: Start a database mirroring endpoint

PS C:\> Set-SqlHADREndpoint -Path "SQLSERVER:\Sql\Computer\Instance\Endpoints\MainDbmEndpoint" -State Started

This command starts the database mirroring endpoint named MainDbmEndpoint on the server instance Computer\Instance.

参数

-AuthenticationOrder

Specifies the order and type of authentication that is used by the endpoint. . If the specified option calls for a certificate, the Certificate parameter must be set unless a certificate is already associated with the endpoint. Valid values are:

  • Certificate
  • CertificateKerberos
  • CertificateNegotiate
  • CertificateNtlm
  • Kerberos
  • KerberosCertificate
  • Negotiate
  • NegotiateCertificate
  • Ntlm
  • NtlmCertificate

参数属性

类型:EndpointAuthenticationOrder
默认值:None
支持通配符:False
不显示:False

参数集

(All)
Position:Named
必需:False
来自管道的值:False
来自管道的值（按属性名称）:False
来自剩余参数的值:False

-Certificate

Specifies the name of the certificate the endpoint will use to authenticate connections. The far endpoint must have a certificate with the public key matching the private key of the specified certificate.

参数属性

类型:String
默认值:None
支持通配符:False
不显示:False

参数集

(All)
Position:Named
必需:False
来自管道的值:False
来自管道的值（按属性名称）:False
来自剩余参数的值:False

-Confirm

Prompts you for confirmation before running the cmdlet.

参数属性

类型:SwitchParameter
默认值:False
支持通配符:False
不显示:False
别名:cf

参数集

(All)
Position:Named
必需:False
来自管道的值:False
来自管道的值（按属性名称）:False
来自剩余参数的值:False

-Encryption

Specifies the endpoint encryption setting. Valid values are:

  • Disabled
  • Supported
  • Required

参数属性

类型:EndpointEncryption
默认值:None
支持通配符:False
不显示:False

参数集

(All)
Position:Named
必需:False
来自管道的值:False
来自管道的值（按属性名称）:False
来自剩余参数的值:False

-EncryptionAlgorithm

Specifies the form of encryption used by the endpoint. Valid values are:

  • Aes
  • AesRC4
  • None
  • RC4
  • RC4Aes

The RC4 algorithm is only supported for backward compatibility. New material can only be encrypted using RC4 or RC4_128 when the database is in compatibility level 90 or 100, but this is not recommended. For improved security, use a newer algorithm such as one of the AES algorithms instead.

参数属性

类型:EndpointEncryptionAlgorithm
默认值:None
支持通配符:False
不显示:False

参数集

(All)
Position:Named
必需:False
来自管道的值:False
来自管道的值（按属性名称）:False
来自剩余参数的值:False

-InputObject

Specifies the endpoint that to modify. This must be a database mirroring endpoint.

参数属性

类型:Endpoint
默认值:None
支持通配符:False
不显示:False

参数集

ByObject
Position:2
必需:True
来自管道的值:True
来自管道的值（按属性名称）:False
来自剩余参数的值:False

-IpAddress

Specifies the IP address on which the endpoint will listen.

参数属性

类型:IPAddress
默认值:None
支持通配符:False
不显示:False

参数集

(All)
Position:Named
必需:False
来自管道的值:False
来自管道的值（按属性名称）:False
来自剩余参数的值:False

-Owner

Specifies the owner of the endpoint.

参数属性

类型:String
默认值:None
支持通配符:False
不显示:False

参数集

(All)
Position:Named
必需:False
来自管道的值:False
来自管道的值（按属性名称）:False
来自剩余参数的值:False

-Path

Specifies the path to the database mirroring endpoint. This is an optional parameter. If not specified, the current working location is used.

参数属性

类型:String
默认值:None
支持通配符:False
不显示:False

参数集

ByPath
Position:2
必需:False
来自管道的值:False
来自管道的值（按属性名称）:False
来自剩余参数的值:False

-Port

Specifies the TCP port number used by the endpoint to listen for connections.

参数属性

类型:Int32
默认值:None
支持通配符:False
不显示:False

参数集

(All)
Position:Named
必需:False
来自管道的值:False
来自管道的值（按属性名称）:False
来自剩余参数的值:False

-Script

Indicates that this cmdlet outputs a Transact-SQL script that performs the task.

参数属性

类型:SwitchParameter
默认值:None
支持通配符:False
不显示:False

参数集

(All)
Position:Named
必需:False
来自管道的值:False
来自管道的值（按属性名称）:False
来自剩余参数的值:False

-State

Specifies the state of the endpoint. Valid values are:

  • Started
  • Stopped
  • Disabled

参数属性

类型:EndpointState
默认值:None
支持通配符:False
不显示:False

参数集

(All)
Position:Named
必需:False
来自管道的值:False
来自管道的值（按属性名称）:False
来自剩余参数的值:False

-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

参数属性

类型:SwitchParameter
默认值:False
支持通配符:False
不显示:False
别名:wi

参数集

(All)
Position:Named
必需:False
来自管道的值:False
来自管道的值（按属性名称）:False
来自剩余参数的值:False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

输入

SMO.Endpoint

输出

SMO.Endpoint