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 ...
Get Microsoft® SQL Server 2012 Unleashed 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.
