O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

  1. Start SQL Server Management Studio. In Object Explorer view, connect to the server you want to act as the principal.

  2. Right-click the database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required