Create a Database Mirroring Endpoint for AlwaysOn Availability Groups (SQL Server PowerShell)

This topic describes how to create a database mirroring endpoint for use by AlwaysOn Availability Groups in SQL Server 2012 by using PowerShell.

In This Topic

• Before you begin:  Security

• To create a database mirroring endpoint, using:  PowerShell

Before You Begin

Security

Uwaga dotycząca zabezpieczeń
The RC4 algorithm is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. We recommend that you use AES.

Permissions

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

[Top]

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.

Ważne:
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"

[Top]

Related Tasks

To Configure a Database Mirroring Endpoint

• Create a Database Mirroring Endpoint for Windows Authentication (Transact-SQL)

• Use Certificates for a Database Mirroring Endpoint (Transact-SQL)

  • Allow a Database Mirroring Endpoint to Use Certificates for Outbound Connections (Transact-SQL)

  • Allow a Database Mirroring Endpoint to Use Certificates for Inbound Connections (Transact-SQL)

• Specify a Server Network Address (Database Mirroring)

• Specify the Endpoint URL When Adding or Modifying an Availability Replica (SQL Server)

To View Information About the Database Mirroring Endpoint

• sys.database_mirroring_endpoints (Transact-SQL)

[Top]

Zobacz także

Koncepcje

Create an Availability Group (Transact-SQL)

Overview of AlwaysOn Availability Groups (SQL Server)