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 |
|---|---|
Describes the prerequisites and recommendations for setting up database mirroring. |
|
Describes the steps for setting up database mirroring. |
|
Discusses how the database mirroring endpoint functions. |
|
Discusses the authentication and encryption options supported on the database mirroring endpoint. |
|
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. |
|
Contains information about enabling automatic decryption of the database master key of a mirror database. |
|
Describes creating a login for a remote server instance that is using a different account than the local server instance. |
|
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. |
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