Database Mirroring How-to Topics

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

Microsoft SQL Server Management Studio

• How to: Launch the Configuring Database Mirroring Security Wizard (SQL Server Management Studio)
• How to: Configure a Database Mirroring Session (SQL Server Management Studio)
• How to: Add or Replace a Database Mirroring Witness (SQL Server Management Studio)
• How to: Remove the Witness from a Database Mirroring Session (SQL Server Management Studio)
• How to: Launch Database Mirroring Monitor
• How to: Manually Fail Over a Database Mirroring Session (SQL Server Management Studio)
• How to: Pause or Resume a Database Mirroring Session (SQL Server Management Studio)
• How to: Remove Database Mirroring (SQL Server Management Studio)
• How to: View the State of a Mirrored Database (SQL Server Management Studio)

Transact-SQL

• How to: Allow Database Mirroring Network Access Using Windows Authentication (Transact-SQL)
• How to: Change Transaction Safety in a Database Mirroring Session (Transact-SQL)
• How to: Create a Mirroring Endpoint for Windows Authentication (Transact-SQL)
• How to: Allow Database Mirroring to Use Certificates for Outbound Connections (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: Force Service in a Database Mirroring Session (Transact-SQL)
• How to: Manually Fail Over a Database Mirroring Session (Transact-SQL)
• How to: Pause a Database Mirroring Session (Transact-SQL)
• How to: Resume a Database Mirroring Session (Transact-SQL)
• How to: Remove Database Mirroring (Transact-SQL)
• How to: Remove the Witness from a Database Mirroring Session (Transact-SQL)

Configuring Availability How-to Topics

Getting SQL Server 2005 Assistance