Database Mirroring Deployment How-to Topics

This section describes how to set up database mirroring. For more information about database mirroring concepts, see Database Mirroring Administration.

SQL Server Management Studio

• How to: Start the Configuring Database Mirroring Security Wizard (SQL Server Management Studio)

• How to: Configure a Database Mirroring Session (SQL Server Management Studio)

Transact-SQL

• How to: Allow Database Mirroring Network Access Using Windows Authentication (Transact-SQL)

• How to: Allow Database Mirroring to Use Certificates for Outbound Connections (Transact-SQL)

• How to: Allow Database Mirroring to Use Certificates for Inbound Connections (Transact-SQL)

• How to: Create a Mirroring Endpoint for Windows Authentication (Transact-SQL)

• How to: Prepare a Mirror Database for Mirroring (Transact-SQL)

• How to: Establish a Database Mirroring Session Using Windows Authentication (Transact-SQL)

• How to: Add a Database Mirroring Witness Using Windows Authentication (Transact-SQL)

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

• How to: Minimize Downtime for Mirrored Databases When Upgrading Server Instances

• How to: Install a Service Pack on a System with Minimal Downtime for Mirrored Databases