Microsoft® SQL Server® 2012 Bible

687 Chapter 27: Database Mirroring 27 ■ (^) By default, it does not support reporting. If you want to use the mirror database fo ...

688 Part V: Enterprise Data Management ■ (^) Like log shipping, database mirroring provides redundancy at the database level and ...

689 Chapter 27: Database Mirroring 27 ■ (^) The principal server is the main production SQL Server to which clients connect. Thi ...

690 Part V: Enterprise Data Management it provides full data safety. The sequence of events when you choose safety full is descr ...

691 Chapter 27: Database Mirroring 27 FIGURE 27-1 Synchronous database mirroring mode. 1 5 2 4 2 >2 3 >3 Client Principal ...

692 Part V: Enterprise Data Management performance, but a heavy load on the principal database or a network delay could cause th ...

693 Chapter 27: Database Mirroring 27 Confi guring Database Mirroring You can confi gure database mirroring using one of two met ...

694 Part V: Enterprise Data Management ■ (^) All the SQL Servers in database mirroring confi guration need to trust each other. ...

695 Chapter 27: Database Mirroring 27 FIGURE 27-3 Selecting the witness server to save the security confi guration. FIGURE 27-4 ...

696 Part V: Enterprise Data Management On the Mirror Server Instance page, click the Connect button to display the Connect to S ...

697 Chapter 27: Database Mirroring 27 On the Service Accounts page type the service accounts for all the SQL Server instances ( ...

698 Part V: Enterprise Data Management FIGURE 27-7 Start database mirroring. FIGURE 27-8 Database mirroring started. c27.indd 69 ...

699 Chapter 27: Database Mirroring 27 Configuring Database Mirroring Using Transact-SQL Like most other confi gurations, you can ...

700 Part V: Enterprise Data Management FROM DISK = 'C:\AdventureWorksLog.bak' WITH NORECOVERY; Execute the following code on th ...

701 Chapter 27: Database Mirroring 27 Checking Database Mirroring Confi guration After database mirroring is confi gured, you ca ...

702 Part V: Enterprise Data Management TABLE 27-2 Querying the sys.database_mirroring Catalog View Column Name Principal Server ...

703 Chapter 27: Database Mirroring 27 partner_sync_state_desc FROM sys.database_mirroring_witnesses; TABLE 27-3 Querying the sys ...

704 Part V: Enterprise Data Management the mirror server, and click Connect. This brings you back to the Register Mirrored Datab ...

705 Chapter 27: Database Mirroring 27 If there is no traffi c produced from the principal to the mirror, the Database Mirroring ...

706 Part V: Enterprise Data Management FIGURE 27-12 Setting warning thresholds. FIGURE 27-13 Database mirroring warnings. c27.in ...