Database Mirroring
Mirroring allows you to create hot standby servers. SQL Server 2008 allows you to mirror any database except for master, msdb, temp, and model. You can configure and enable mirroring by using the Mirroring page in the Database Properties dialog box. As discussed in "Ensuring Availability and Scalability", mirroring requires up to three servers: a principal server, a mirror server, and a witness server.
Database Mirroring Essentials
The principal server is the source server with the principal database in the mirror pair. The mirror server is the target server with the target database in the mirror pair. The witness server is an optional monitoring server that is preferably physically separate from the principal and mirror.
SQL Server ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
