Microsoft® SQL Server 2012 Unleashed

Configuring Database Mirroring by Using the Wizard

Typically, you will use the wizard to create the database mirroring endpoints and establish the roles. Regardless, to get this to work properly, you’ll have to make sure that you manually back up and restore the database that you are planning to mirror with the scripts provided. Figure 41.7 shows the Mirror option from the AdventureWorks2012 database (reached by right-clicking the database name) from what will be the principal server. Because this database is not enabled for mirroring yet, you must run through the Configure Security option on the top portion of the Mirroring page (refer to Figure 41.6). The principal, mirror, and witness network server addresses will get established and identified ...