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.
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 ...