Share via


Setting Up Database Mirroring

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

Important

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

In This Section

Topic Description

Prerequisites and Recommendations for Database Mirroring

Describes the prerequisites and recommendations for setting up database mirroring.

Overview of Database Mirroring Setup

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.

See Also

Tasks

How to: Set Up a Mirror Database to Use the Trustworthy Property

Concepts

Database Mirroring Sessions
Database Mirroring Transport Security
Database Mirroring and Backup and Restore
Managing Database Mirroring (SQL Server Management Studio)
Overview of Database Mirroring
Troubleshooting Database Mirroring Setup

Help and Information

Getting SQL Server 2005 Assistance