Database Mirroring Administration
SQL Server 2008 Books Online (November 2009)
Database Mirroring Administration

Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring. Database mirroring is supported in SQL Server Standard and Enterprise.

Database mirroring offers a substantial improvement in availability over the level previously possible using Microsoft SQL Server and provides an easy-to-manage alternative or supplement to failover clustering or log shipping. When a database mirroring session is synchronized, database mirroring provides a hot standby server that supports rapid failover with no loss of data from committed transactions. During a typical mirroring session, after a production server fails, client applications can recover quickly by reconnecting to the standby server.

ms177412.note(en-us,SQL.100).gifNote:
You cannot mirror the master, msdb, temp, or model databases.

In This Section

Pausing and Resuming Database Mirroring

Explains how to pause and resume a session using Transact-SQL.

Removing Database Mirroring

Explains how to end a session using Transact-SQL.

Managing Database Mirroring (SQL Server Management Studio)

Introduces database mirroring administration using SQL Server Management Studio, which provides a properties page for database mirroring and a wizard for configuring database mirroring security.

Database Mirroring Administration How-to Topics (Database Engine)

Contains topics describing database mirroring.

See Also

Concepts

Recovery Model Overview

Other Resources

High Availability: Interoperability and Coexistence

Help and Information

Getting SQL Server 2008 Assistance
© 2010 Microsoft Corporation. All rights reserved.   Terms of Use | Trademarks | Privacy Statement
Page view tracker
Rate the Lightweight library
x
Lightweight builds on ScriptFree (loband) by adding features you've requested: a SearchBox and default code language selection.
Do you like the SearchBox?
Do you like the tabbed code blocks?
How useful is this topic?
Tell us more.
Thanks
x
You're helping to improve MSDN Online.
Feedback
Switch View
Classic
Lightweight Beta
ScriptFree
Switch View