Database Mirroring How-to Topics
SQL Server 2005
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)
