Mirroring Databases
Mirroring allows you to create hot standby servers. SQL Server 2005 allows you to mirror any database except for master, msdb, temp, and model. You can configure and enable mirroring using the Mirroring page in the Database Properties dialog box. As discussed in Chapter 2 in the subsection titled "Ensuring Availability and Scalability," mirroring requires up to three servers: a principal server, a mirror server, and a witness server.
Configuring Mirroring
After you have installed SQL Server 2005 on the servers that will be used in mirroring, you must prepare for mirroring by doing the following:
Start SQL Server Management Studio. In Object Explorer view, connect to the server you want to act as the principal.
Right-click the database ...
Get Microsoft® SQL Server™ 2005 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.
