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
We recommend that you configure database mirroring during off-peak hours because configuration can impact performance.
In This Section
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.
See Also