Setting Up Database Mirroring

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.

Tasks

Concepts