Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Setting Up Database Mirroring

This section describes the prerequisites, recommendations, and steps for setting up database mirroring. For an introduction to database mirroring, see Database Mirroring Overview.

Important noteImportant

We recommend that you configure database mirroring during off-peak hours because configuration can impact performance.

Prerequisites, Restrictions, and Recommendations for Database Mirroring

Describes the prerequisites and recommendations for setting up database mirroring.

Database Mirroring Setup Overview

Describes the steps for setting up database mirroring.

Database Mirroring Endpoint

Discusses how the database mirroring endpoint functions.

Database Mirroring Transport Security

Discusses the authentication and encryption options supported on the database mirroring endpoint.

Preparing a Mirror Database for Mirroring

Summarizes the steps for creating a mirror database or preparing a mirror database before resuming a suspended session. Also provides links to how-to topics.

Setting Up an Encrypted Mirror Database

Contains information about enabling automatic decryption of the database master key of a mirror database.

Setting Up Login Accounts for Database Mirroring

Describes creating a login for a remote server instance that is using a different account than the local server instance.

Specifying a Server Network Address (Database Mirroring)

Describes the syntax of a server network address, how the address identifies the database mirroring endpoint of the server instance, and how to find the fully-qualified domain name of a system.

Example: Setting Up Database Mirroring Using Windows Authentication (Transact-SQL)

Contains an example of all the stages required to create a database mirroring session with a witness, using Windows Authentication.

Using Certificates for Database Mirroring

Describes the steps for configuring certificates for inbound connections and outbound connections.

Example: Setting Up Database Mirroring Using Certificates (Transact-SQL)

Contains an example of all the stages required to create a database mirroring session with a witness, using certificate-based authentication.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.