Muokkaa

Jaa

Create a database mirroring endpoint for an availability group using PowerShell

  • Artikkeli

Applies to: SQL Server

This topic describes how to create a database mirroring endpoint for use by Always On availability groups in SQL Server by using PowerShell.

Permissions

Requires CREATE ENDPOINT permission, or membership in the sysadmin fixed server role. For more information, see GRANT Endpoint Permissions (Transact-SQL).

Important

The RC4 algorithm is deprecated. This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. We recommend that you use AES.

Using PowerShell

To create a database mirroring endpoint

  1. Change directory (cd) to the server instance for which you want to create the database mirroring endpoint.

  2. Use the New-SqlHadrEndpoint cmdlet to create the endpoint and then use the Set-SqlHadrEndpoint to start the endpoint.

Example (PowerShell)

The following PowerShell commands create a database mirroring endpoint on an instance of SQL Server (Machine\Instance). The endpoint uses port 5022.

Important

This example works only on a server instance that currently lack a database mirroring endpoint.

# Create the endpoint.  
$endpoint = New-SqlHadrEndpoint MyMirroringEndpoint -Port 5022 -Path SQLSERVER:\SQL\Machine\Instance  
  
# Start the endpoint  
Set-SqlHadrEndpoint -InputObject $endpoint -State "Started"

Related Tasks

To Configure a Database Mirroring Endpoint

To View Information About the Database Mirroring Endpoint

See Also

Create an Availability Group (Transact-SQL)
Overview of Always On Availability Groups (SQL Server)