O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

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

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

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